In: Accounting
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 52,900 units will be produced, with the following total costs:
Direct materials | ? |
Direct labor | 54,000 |
Variable overhead | 20,000 |
Fixed overhead | 245,000 |
Next year, Pietro expects to purchase $121,000 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 | $7,000 | $12,900 |
Ending | $6,900 | $14,900 |
Next year, Pietro expects to produce 52,900 units and sell 52,200 units at a price of $15.00 each. Beginning inventory of finished goods is $41,500, and ending inventory of finished goods is expected to be $33,000. Total selling expense is projected at $28,500, and total administrative expense is projected at $116,000.
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 | |||
$ | % | ||
% | |||
$ | % | ||
Less operating expenses: | |||
$ | |||
% | |||
$ | % |
2. What if the cost of goods sold percentage for the past few years was 52.04 percent? Management's reaction might be:
1) | |||
SCHEDULE OF COST OF GOODS MANUFACTURED | |||
Beginning WIP | 12900 | ||
Direct materials cost: | |||
Beginning direct materials inventory | 7000 | ||
Purchases of direct materials | 121000 | ||
Total direct materials available | 128000 | ||
Ending direct materials inventory | 6900 | ||
Direct materials cost | 121100 | ||
Direct labor cost | 54000 | ||
Variable overhead | 20000 | ||
Fixed overheads | 245000 | ||
Total manufacturing cost | 453000 | ||
Ending WIP inventory | 14900 | ||
Cost of goods manufactured | 438100 | ||
SCHEDULE OF COST OF GOODS SOLD | |||
Beginning inventory of finished goods | 41500 | ||
Cost of goods manufactured | 438100 | ||
Total goods available for sale | 479600 | ||
Ending inventory of finished goods | 33000 | ||
Cost of goods sold | 446600 | ||
INCOME STATEMENT | |||
Sales revenue (52200 units at $15.00) | 783000 | 100.00% | |
Cost of goods sold | 446600 | 57.04% | |
Gross profit | 336400 | 42.96% | |
Less: Operating expenses: | |||
Selling expenses | 28500 | ||
Administrative expenses | 116000 | 144500 | 18.45% |
Net operating income | 191900 | 24.51% | |
2) Investigate production cost management. | |||
The reasons for increase in cost during the year is to be investigated. |