Job Costs Using a Plantwide Overhead Rate

Naranjo Company designs industrial prototypes for outside companies. Budgeted overhead for the year was $212,500, and budgeted direct labor hours were 17,000. The average wage rate for direct labor is expected to be $25 per hour. During June, Naranjo Company worked on four jobs. Data relating to these four jobs follow:

Sales Forecast and Flexible Budget

Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,130 for the Sleepeze, 12,360 for the Plushette, and 4,740 for the Ultima. Gene Dixon, vice president of sales, has provided the following information:

1. Salaries for his office (including himself at $64,000, a marketing research assistant at $38,750, and an administrative assistant at $22,700) are budgeted for $125,450 next year.
2. Depreciation on the offices and equipment is $21,850 per year.
3. Office supplies and other expenses total $19,300 per year.
4. Advertising has been steady at $21,300 per year. However, the Ultima is a new product and will require extensive advertising to educate consumers on the unique features of this high-end mattress. Gene believes the company should spend 15 percent of first-year Ultima sales for a print and television campaign.
5. Commissions on the Sleepeze and Plushette lines are 6 percent of sales. These commissions are paid to independent jobbers who sell the mattresses to retail stores.
6. Last year, shipping for the Sleepeze and Plushette lines averaged $55 per unit sold. Gene expects the Ultima line to ship for $70 per unit sold since this model features a larger mattress.

Required:

1. Suppose that Gene is considering three sales scenarios as follows:

	Pessimistic			Expected			Optimistic
	Price	Quantity		Price	Quantity		Price	Quantity
Sleepeze	$190	12,990		$205	15,130		$205	17,750
Plushette	293	9,820		337	12,360		349	14,230
Ultima	850	2,220		980	4,740		1,150	4,740

Prepare a revenue budget for the Sales Division for the coming year for each scenario.

Olympus, Inc.
Revenue Budget
For the Coming Year
	Pessimistic	Expected	Optimistic
Sleepeze	$	$	$
Plushette
Ultima
Total sales	$	$	$

2. Prepare a flexible expense budget for the Sales Division for the three scenarios above. If required, round answers to the nearest dollar.

Olympus, Inc.
Flexible Expense Budget
For the Coming Year
	Pessimistic	Expected	Optimistic
Salaries	$	$	$
Depreciation
Office supplies and other
Advertising:
Sleepeze and Plushette
Ultima
Commissions
Shipping:
Sleepeze
Plushette
Ultima
Total	$	$	$

Overhead is assigned as a percentage of direct labor cost. During June, Jobs 39 and 40 were completed; Job 39 was sold at 125 percent of cost. (Naranjo had originally developed Job 40 to order for a customer; however, that customer was near bankruptcy and the chance of Naranjo being paid was growing dimmer. Naranjo decided to hold Job 40 in inventory while the customer worked out its financial difficulties. Job 40 is the only job in Finished Goods Inventory.) Jobs 41 and 42 remain unfinished at the end of the month.

Required:

1. Calculate the balance in Work in Process as of June 30.

$

2. Calculate the balance in Finished Goods as of June 30.

$

3. Calculate the cost of goods sold for June.

$

4. Calculate the price charged for Job 39. Round your answer to the nearest cent.

$

5. What if the customer for Job 40 was able to pay for the job by June 30? What would happen to the balance in Finished Goods?

What would happen to the balance of Cost of Goods Sold?