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] |