In: Accounting
Income Statement
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 53,700 units will be produced, with the following total costs:
Direct materials | ? |
Direct labor | 72,000 |
Variable overhead | 23,000 |
Fixed overhead | 250,000 |
Next year, Pietro expects to purchase $127,500 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows:
Direct materials Inventory |
Work-in-Process Inventory |
|
Beginning | $6,000 | $13,300 |
Ending | $5,900 | $15,300 |
Next year, Pietro expects to produce 53,700 units and sell
53,000 units at a price of $17.00 each. Beginning inventory of
finished goods is $42,500, and ending inventory of finished goods
is expected to be $34,000. Total selling expense is projected at
$29,500, and total administrative expense is projected at
$112,500.
Required:
1. Prepare an income statement in good form. Round the percent to four decimal places before converting to a percentage. For example, .88349 would be rounded to .8835 and entered as 88.35.
Pietro Frozen Foods, Inc. | |||
Income Statement | |||
For the Coming Year | |||
Percent | |||
Sales | $ | % | |
Cost of goods sold | % | ||
Gross margin | $ | % | |
Less operating expenses: | |||
Selling expenses | $ | ||
Administrative expenses | % | ||
Operating income | $ |
% |
2. What if the cost of goods sold percentage for the past few years was 50.17 percent? Management's reaction might be:
Solution
Pietro Frozen Foods, Inc. | |||
Income Statement | |||
For the Coming Year | |||
Percent | |||
Sales | $ 901,000 | 100.00% | |
Cost of goods sold | $ 479,100 | 53.17% | |
Gross margin | $ 421,900 | 46.83% | |
Less operating expenses: | |||
Selling expenses | $ 29,500 | ||
Administrative expenses | $ 112,500 | $ 142,000 | 15.76% |
Operating income | $ 279,900 | 31.07% |
.
Working for cost of goods sold
Cost of Goods Manufactured and Cost of goods sold | |||
Beginning Work in process | $ 13,300 | ||
Direct materials used | |||
Raw material Inventory Beginning | $ 6,000 | ||
Raw material Purchased | $ 127,500 | ||
Raw material available for use | $ 133,500 | ||
Less: Raw material Inventory Ending | $ 5,900 | ||
Direct Material Used | $ 127,600 | ||
Direct labor | $ 72,000 | ||
Manufacturing Overheads | $ 273,000 | ||
Total manufacturing cost incurred during the year | $ 472,600 | ||
Total manufacturing cost to account for | $ 485,900 | ||
Less: Ending WIP inventory | $ 15,300 | ||
Cost of goods manufactured | $ 470,600 | ||
Add: Beginning Finished goods inventory | $ 42,500 | ||
Goods available for sale | $ 513,100 | ||
Less: Ending Finished goods inventory | $ 34,000 | ||
Cost of goods sold | $ 479,100 |