The question is in the picture Gmail100% -=1Newsment✩ DInsert Format Tools Extensions HelpTranslate Opulence Global ...Normal textY1.Arial2Last edit was 4 minutes agoI U A1180+B3 ... 11a) Determine the function describing the monthly profit.b) Calculate the profit made by selling 16 items per month.415CBefore starting production of a new product, the Board of Directors of the company that employsyou asks you to do a profitability study. To produce this article, it would be necessary to proceedwith the purchase of devices whose payment would be made by monthly installments of $1,600.In addition, there is a cost of $25 per unit and the determined selling price is $110.6c) Calculate the profit made by selling 28 items per month.d) Graph the function describing the profit and determine the monthly break-even point for thisproduct.e) What recommendation should be made to the board of directors?

Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Answered: Before starting production of a new…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 6R: Reset cells to their initial values. Sweet Pleasures, Inc., is considering undertaking a 1,200 per...

See similar textbooks

Similar questions

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take pictures) Company X, S.A.'s current sales are 12.5 million. An increase of 5% is estimated for next year, and its uncollectible accounts will go from the current 1% to 1.5%. What is the change in profit due to this customer behavior? A) 1,500 B) 3,000 C) 4,500 D) 5,000 (Choose a option)
i will 10 upvotes urgent Assume the annual retention rate for a cell phone subscriber is 70 percent and the customer generates $300 per year in profit. Assuming an annual discount rate of 8 percent, compute the value of a customer. Please use excel worksheet to solve and show formulas
Consider a firm with a 2010 revenue of S60 million and cost of goods sold of $25 million lf the balance shert amount show $4million of inventory and $1.5 million ofproperty, plant & equipment how many weeks of suppiy does the fim bolat(2 weeksinoneyear)(use 2 decimals)Select oneO a.8.33O b.6.25Oc 13.75O d. 400Oe 12.50
Matthew's Fish Fry has a monthly target operating income of $6600. Variable expenses are 80% of sales and monthly fixed expenses are $840. What is the monthly margin of safety in dollars if the business achieves its operating income goal? Question 20 options: $29,760 $37,200 $33,000 $41,400
SOLVE STEP BY STEP IN DIGITAL FORMAT DONT USE CHATGPT The papelitos company manufactures and sells personalized thermoses. Currently, 10,000 units are sold per year at a price of $320 per unit. Fixed costs are $40,000 monthly. Variable costs are $210 per unitYou are asked to calculate the number of units that need to be sold per month to reach the break-even point.Interpret the resultCalculate the units you must sell per month to obtain a profit of $14,000 per month.Perform the respective verification of the two previous points.
Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), 1,616,000; Net income (cell C38), 95,000.
Unearned Sales Revenue Brand Landscaping offers a promotion where a customers lawn will be mowed 20 times if the customer pays $700 in advance. Required: Prepare the journal entry to record (1) the customers' prepayment of S700 and (2) Brands mowing of the lawn one time.
company X produce and sell 80000 calculators yearly. the capacity for company to produce 100000 calculators . the next data available the variable cost per calculator: manufacturing cost 22 selling and administrative 10 the fixed cost: manufacturing cost 256000 selling and administrative 112000 if the company accepted to special order to sell 10000 calculator at selling price 50 per calculator. whats the effect of the company income?
Plz solve correctly. An automotive supply store sells a product that has a demand of 400 units per month. Its supplier charges an ordering cost of $60 per order and $25 per unit with a 20% discount for orders of 250 units or higher. The store incurs a 20% annual holding cost. What is the store’s total annual cost (purchasing, ordering, and holding) if it orders at a quantity of 300 units? a. $121,560 b. $96,000 c. $120,000 d. $97,560
Question A All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales $ 77,300 $ 80,750 $ 87,150 $ 95,040 The company places orders each quarter that are 65 percent of the following quarter's sales and has a 60-day payables period. What is the accounts payable balance at the end of the third quarter? Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line.
Firm: FedEx • 140 accounts in the advertising industry use 2,285 Courier Packs (CP) per month • CP price is $12.50 and variable cost is $4.25 • Retention rate=0.9, discount rate=12% • What is the maximum FedEx should be willing to spend to acquire a new account in this industry?
a) Company XYZ has a monthly rental amount of 2000 USD, credit payments (1200 per year), materials 30USD, Labor 70 USD, Unit selling price is 150$. Please find BEP and prepare a profit and loss statement. Going forward company also decided to look at their productivity from a multifactor perspective. To do so, CEO has determined his labor, capital, energy and material usage and has decided to use dollar as the common denominator. His total labor hours are now 300 per day and will increase to 308 per day. His capital and energy costs will remain constant at $350 and $150 per day respectively. Material costs for 100 logs per day are $1000 and will remain the same. Because he pays an average of $10 per hour. Please calculate the productivity for current system and with professional buyer.

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Quickbooks Online Accounting

Accounting

ISBN:

9780357391693

Author:

Owen

Publisher:

Cengage

SEE MORE TEXTBOOKS