In: Accounting
Please fill in the 4 blanks in the spreadsheet.
Assume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation.
| Marley's Manufacturing Income Statement Month Ending August 31, 2018  | ||||
| Dept. A | Dept. B | |||
| Sales | $23,000 | $51,000 | ||
| Cost of goods sold | 11,040 | 26,520 | ||
| Gross profit | $11,960 | $24,480 | ||
| Expenses: | ||||
| Utility expenses | $1,380 | $3,060 | ||
| Wages expense | 5,750 | 10,200 | ||
| Costs allocated from corporate | 2,530 | 14,280 | ||
| Total expenses | $9,660 | $27,540 | ||
| Operating income/(loss) in dollars | $fill in the blank 1 | $fill in the blank 2 | ||
| Operating income/(loss) in percentage | fill in the blank 3 | % | fill in the blank 4 | % | 
| 
 Marley's Manufacturing  | 
||||
| 
 Income Statement  | 
||||
| 
 Month Ending August 31, 2018  | 
||||
| 
 Dept. A  | 
 Dept. B  | 
|||
| 
 Sales  | 
 $23,000  | 
 $51,000  | 
||
| 
 Cost of goods sold  | 
 $11,040  | 
 $26,520  | 
||
| 
 Gross profit  | 
 $11,960  | 
 $24,480  | 
||
| 
 Expenses:  | 
||||
| 
 Utility expenses  | 
 $1,380  | 
 $3,060  | 
||
| 
 Wages expense  | 
 $5,750  | 
 $10,200  | 
||
| 
 Costs allocated from corporate  | 
 $2,530  | 
 $14,280  | 
||
| 
 Total expenses  | 
 $9,660  | 
 $27,540  | 
||
| 
 Operating income/(loss) in dollars  | 
 $2,300  | 
 [$11960 - 9660]  | 
 ($3,060)  | 
 [$24480 - 27540]  | 
| 
 Operating income/(loss) in percentage  | 
 10.00%  | 
 [($2300/23000) x 100]  | 
 -6.00%  | 
 [($3060)/$51000) x 100]  |