Miller Cereals is a small milling company that makes a single brand of cereal. Recently, a business school intern recommended that the company introduce a second cereal in order to “diversify the product portfolio.” Currently, the company shows an operating profit that is 20 percent of sales. With the single product, other costs were twice the cost of rent.
The intern estimated that the incremental profit of the new cereal would only be 2.5 percent of the incremental revenue, but it would still add to total profit. On his last day, the intern told Miller’s marketing manager that his analysis was on the company laptop in a spreadsheet with a file name, NewProduct.xlsx. The intern then left for a 12-month walkabout in the outback of Australia and cannot be reached.
When the marketing manager opened the file, it was corrupted and could not be opened. She then found an early (incomplete) copy on the company’s backup server. The incomplete spreadsheet is shown following. The marketing manager then called a cost
Required
As the management accountant, fill in the blank cells.
Fill in the blank cells of the projected income statement.
Explanation of Solution
Projected income statement: The projected income statement represents the future financial position of the entity. The projected income statement is prepared with an objective of showing the financial results for a future period of time.
Fill in the blank cells of the projected income statement:
Company M | ||||
Projected Income Statement | ||||
For One Year | ||||
Status Quo: | % Increase | Alternative | ||
Single Product | Decrease | Two Products | Difference | |
Sales revenue | $ 150,000 (a) | 40% | $ 210,000 (b) | $ 60,000 |
Costs | ||||
Material | $ 40,000 | 50% (j) | $ 60,000 | $ 20,000 (k) |
Labor | $ 50,000 (l) | 20% | $ 60,000 | $ 10,000 (m) |
Rent | $ 6,000 (q) | 50% | $ 9,000 (s) | $ 3,000 (u) |
Depreciation | $ 8,000 | 0% (n) | $ 8,000 | $ - |
Utilities | $ 4,000 (o) | 25% (p) | $ 5,000 | $ 1,000 |
Other | $ 12,000 (r) | $ 36,500 (t) | $ 24,500 (v) | |
Total costs | $ 120,000 (g) | $ 178,500 (i) | $ 58,500 (h) | |
Operating profit | $ 30,000 (c) | 5% (f) | $ 31,500 (e) | $ 1,500 (d) |
Table (1)
Working note 1:
Compute the value of (a):
It is given that the profit has increased by 40%. (a) represents the amount of sales revenue.
Working note 2:
Compute the value of (b):
Working note 3:
Compute the value of (c):
Working note 4:
Compute the value of (d):
Working note 5:
Compute the value of (e):
Working note 5:
Compute the value of (f):
Working note 6:
Compute the value of (g):
Working note 6:
Compute the value of (h):
Working note 7:
Compute the value of (i):
Working note 8:
Compute the value of (j):
Working note 9:
Compute the value of (k):
Working note 10:
Compute the value of (l):
Working note 11:
Compute the value of (m):
Working note 12:
Compute the value of (n):
The value of n is 0 as there was no change.
Working note 13:
Compute the value of (o):
Working note 14:
Compute the value of (p):
Working note 15:
Compute the value of (q):
Value of rent:
The value of rent is half of the other costs. Thus, the value of rent will be $6,000, and that of other costs will be $12,000.
Thus,
Working note 16:
Compute the value of (r):
Working note 17:
Compute the value of (s):
Working note 18:
Compute the value of (t):
Working note 19:
Compute the value of (u):
Working note 20:
Compute the value of (v):
Want to see more full solutions like this?
Chapter 1 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- Pappy’s Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy’s paid $121,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $576,000 per year. The fixed costs associated with this will be $180,000 per year, and variable costs will amount to 21 percent of sales. The equipment necessary for production of the Potato Pet will cost $622,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 35 percent and a required return of 14 percent. Calculate the payback period for this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Calculate the NPV for this project. (Do not round intermediate calculations and round your answer to 2 decimal places,…arrow_forwardPappy’s Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy’s paid $180,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $895,000 per year. The fixed costs associated with this will be $228,000 per year, and variable costs will amount to 24 percent of sales. The equipment necessary for production of the Potato Pet will cost $970,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 22 percent and a required return of 16 percent. Calculate the Time 0 cash flow for this project. Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. Calculate the annual OCF for this project. Note: Do not round…arrow_forwardPappy's Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy's paid $170,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $885,000 per year. The fixed costs associated with this will be $224,000 per year, and variable costs will amount to 20 percent of sales. The equipment necessary for production of the Potato Pet will cost $950,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 25 percent and a required return of 14 percent. a. Calculate the payback period for this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Calculate the NPV for this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,…arrow_forward
- Pappy’s Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy’s paid $220,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $935,000 per year. The fixed costs associated with this will be $244,000 per year, and variable costs will amount to 24 percent of sales. The equipment necessary for production of the Potato Pet will cost $950,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 25 percent and a required return of 16 percent. a. Calculate the payback period for this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Calculate the NPV for this project. (Do not round intermediate calculations and round your answer to 2 decimal…arrow_forwardPappy's Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy's paid $195,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $910,000 per year. The fixed costs associated with this will be $234,000 per year, and variable costs will amount to 22 percent of sales. The equipment necessary for production of the Potato Pet will cost $1,000,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 25 percent and a required return of 15 percent. a. Calculate the payback period for this project. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. Calculate the NPV for this project. Note: Do not round intermediate calculations and round your answer to 2 decimal…arrow_forwardPappy's Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy's paid $120,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $915,000 per year. The fixed costs associated with this will be $235,000 per year, and variable costs will amount to 20 percent of sales. The equipment necessary for production of the Potato Pet will cost $890,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. The tax rate is 23 percent and the required return is 13 percent. Calculate the payback period, NPV, and IRR.arrow_forward
- Pappy's Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy's paid $160,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $875,000 per year. The fixed costs associated with this will be $220,000 per year, and variable costs will amount to 24 percent of sales. The equipment necessary for production of the Potato Pet will cost $930,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 23 percent and a required return of 16 percent. a. Calculate the payback period for this project. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. Calculate the NPV for this project. Note: Do not round intermediate calculations and round your answer to 2 decimal…arrow_forwardPappy’s Potato has come up with a new product, the Potato Pet (they are freeze-dried to last longer). Pappy’s paid $175,000 for a marketing survey to determine the viability of the product. It is felt that Potato Pet will generate sales of $890,000 per year. The fixed costs associated with this will be $226,000 per year, and variable costs will amount to 22 percent of sales. The equipment necessary for production of the Potato Pet will cost $960,000 and will be depreciated in a straight-line manner for the four years of the product life (as with all fads, it is felt the sales will end quickly). This is the only initial cost for the production. Pappy's has a tax rate of 21 percent and a required return of 15 percent. Calculate the payback period for this project. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Calculate the NPV for this project. Note: Do not round intermediate calculations and round your answer to 2 decimal…arrow_forwardOne Manila Inc.'s president, Zane Cruz, is concerned about the prospects of one of the firm's major products. The president has been reviewing a marketing report with Jom Lara, marketing product manager, for their top-of-the-line stereo amplifier. The report indicates another price reduction is needed to meet anticipated competitors' reduction in sales prices. The current selling price for OMI's amplifier is P35,000 per unit. It is expected that within three months OMI's two major competitors will be selling their comparable amplifiers for P30,000 per unit. This concerns CRUZ because OMI's current cost of producing the amplifiers is P31,500, which yields a P3,500 profit on each unit sold. The situation is especially disturbing because OMI had implemented an activity-based costing (ABC) system about two years ago. The ABC system helped them better identify costs, cost pools, cost drivers, and cost reduction opportunities. Changes made when adopting ABC reduced costs on this…arrow_forward
- After preparing the original estimates, management determined that its variable manufacturing cost of leaf blowers would increase by 20 percent, and the variable selling cost of hedge clippers could be expected to increase by $1.00 per unit. However, management has decided not to change the selling price of either product. In addition, management has learned that its leaf blower has been perceived as the best value on the market, and it can expect to sell three times as many leaf blowers as each of its other products. Under these circumstances, determine how many units of each product CTC would have to sell in order to break even in 20x2.arrow_forwardMcGilla Golf has decided to sell a new line of golf clubs. The company would like to know the sensitivity of NPV to changes in the price of the new clubs and the quantity of new clubs sold. The clubs will sell for $825 per set and have a variable cost of $385 per set. The company has spent $260,000 for a marketing study that determined the company will sell 68,200 sets per year for seven years. The marketing study also determined that the company will lose sales of 12,200 sets of its high-priced clubs. The high-priced clubs sell at $1,195 and have variable costs of $655. The company will also increase sales of its cheap clubs by 14,200 sets. The cheap clubs sell for $415 and have variable costs of $205 per set. The fixed costs each year will be $10,350,000. The company has also spent $2,100,000 on research and development for the new clubs. The plant and equipment required will cost $38,400,000 and will be depreciated on a straight-line basis. The new clubs will also require an…arrow_forwardMcGilla Golf has decided to sell a new line of golf clubs. The company would like to know the sensitivity of NPV to changes in the price of the new clubs and the quantity of new clubs sold. The clubs will sell for $825 per set and have a variable cost of $385 per set. The company has spent $260,000 for a marketing study that determined the company will sell 68,200 sets per year for seven years. The marketing study also determined that the company will lose sales of 12,200 sets of its high-priced clubs. The high-priced clubs sell at $1,195 and have variable costs of $655. The company will also increase sales of its cheap clubs by 14,200 sets. The cheap clubs sell for $415 and have variable costs of $205 per set. The fixed costs each year will be $10,350,000. The company has also spent $2,100,000 on research and development for the new clubs. The plant and equipment required will cost $38,400,000 and will be depreciated on a straight-line basis. The new clubs will also require an…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education