Agnes Manufacturing Company is a producer of sports equipment in Orange Country, California, USA. Inventory data from its most recently concluded year of operations 2021 at 5,000 units of production were as follows: 

Raw materials, Beginning $15,000 Raw materials, Ending $10,000 Work in process, Beginning $25,000 Work in process, Ending $20,000 Finished goods, Beginning $90,000 Finished goods, Ending $85,000 Direct labor was determined to be $300,000; indirect labor (fixed) $40,000; and supervisors in the factory earns $50,000 (fixed) annually. 

General and administrative expenses represent the salaries of executives and management totaling $110,000. Total sales reached $1,200,000 where commissions of 5% were paid to salespersons. Further ledger details were provided by the company bookkeeper: Purchases of raw materials (all direct) $150,000 Indirect materials (variable) $ 5,000 Maintenance in the factory $30,000 Supplies in the factory (variable) $3,000 Depreciation of factory equipment (straight line) $18,000 Depreciation office equipment (straight line) $12,000 As part of its compensation package, the company provides meal tickets to its employees and factory workers. 

This is a fixed amount annually allocated as follows: factory workers $20,000 and office workers $2,000. Due to its shared facilities between the factory and the office, utilities, insurance and rent are allocated on a reasonable basis. It was determined that 95% of the $100,000 in total utilities go to factory operations and the remaining 5% is chargeable to the office. Likewise, the fixed insurance policy for the property amounting to $80,000 is split 80% for the factory and 20% for the office. Rent is fixed at $150,000 and 80% based on a floor area is allocated to the factory and the remaining 20% for the office. Based on earlier experience at a production level of 9,000 units, maintenance costs (mixed) were determined to be $36,000 while utility costs (mixed) in the factory were recorded at $103,000. This is the highest activity level planned and currently, the company is at its lowest production level of 5,000 due to the effect of the pandemic. For decision-making purposes, this was determined as the company’s relevant range. 

Compute the following at the current level of 5,000 production units: 

1. Direct materials used in production 

2. Total manufacturing overhead 

3. Prime costs 

4. Conversion costs 

5. Cost of goods placed in the process 

6. Cost of goods manufactured 

7. Cost of goods available for sale 8. Cost of goods sold 

9. Gross profit 

10. Operating Expenses 

11. Net operating income Compute the following after considering a high-low cost segregation analysis 

12. Manufacturing overhead total variable cost rate per unit (slope) 

13. Manufacturing overhead total fixed cost (intercept) If management plans to manufacture 7,500 units next year compute the following: 

14. The total cost of maintenance in the factory 

15. The total cost of utilities in the factory 

16. Cost function of maintenance 

17. Cost function of utilities If management plans to manufacture 6,000 units next year compute the following: 

18. Total manufacturing overhead 

19. Cost function of total manufacturing overhead 

20. Total manufacturing overhead at 8,000 units of production.