Given the total cost and output for the month at ACME shown below develop a spreadsheet that can calculate the total and per unit values for the accounting entities named here: prime cost, conversion cost, full absorption cost, contribution margin, gross margin, and profit.
Direct Mfg. Materials=$224,000 Variable Marketing & Admin=$89000
Direct Mfg. Labor=$196,000 Fixed Marketing & Admin=$36,000
Variable Mfg. Overhead Labor=$56000 Total Sales Revenue=$832,000
Variable Mfg. Overhead Mtls.=$26000 Units Sold=2200
Fixed Mfg. Overhead=$78000