ACCT300 Week 6 Homework Assignment
Looking for assistance with excel inputs:
E11-7
High-low method
Obj|1
✓ a. $23 per unit
Zeta Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows:
Units Produced | Total Costs |
|---|---|
45,000 | $1,535,000 |
50,000 | 1,650,000 |
70,000 | 2,110,000 |
- a. Determine the variable cost per unit and the fixed cost.
- b. Based on part (a), estimate the total cost for 60,000 units of production.
P12-1
Differential analysis report involving opportunity costs
Obj|1
On November 7, Five Star is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest in $900,000 of 4% U.S. Treasury bonds that mature in 15 years. The bonds could be purchased at face value. The following data have been assembled:
Cost of equipment | $900,000 |
Life of equipment | 15 years |
Estimated residual value of equipment | $100,000 |
Yearly costs to operate the warehouse, excluding depreciation of equipment | $175,000 |
Yearly expected revenues—years 1–7 | $400,000 |
Yearly expected revenues—years 8–15 | $250,000 |
Instructions
- 1. Prepare a report as of November 7, 2012, presenting a differential analysis of the proposed operation of the warehouse for the 15 years as compared with present conditions.
- 2. Based on the results disclosed by the differential analysis, should the proposal be accepted?
- 3. If the proposal is accepted, what is the total estimated income from operations
P12-6
Product pricing and profit analysis with bottleneck operations
Obj|1, 3
✓ 1. Ethylene contribution margin per unit, $100
Palomar Chemical Company produces three products: ethylene, butane, and ester. Each of these products has high demand in the market, and Palomar Chemical is able to sell as much as it can produce of all three. The reaction operation is a bottleneck in the process and is running at 100% of capacity. Palomar Chemical wants to improve chemical operation profitability. The variable conversion cost is $20 per process hour. The fixed cost is $550,000. In addition, the cost analyst was able to determine the following information about the three products:
Ethylene | Butane | Ester | |
|---|---|---|---|
Budgeted units produced | 15,000 | 15,000 | 15,000 |
Total process hours per unit | 6 | 6 | 4 |
Reactor hours per unit | 1.0 | 0.8 | 0.5 |
Unit selling price | $400 | $350 | $250 |
Direct materials cost per unit | $180 | $130 | $90 |
The reaction operation is part of the total process for each of these three products. Thus, for example, 1.0 of the 6 hours required to process ethylene are associated with the reactor.
Instructions
- 1. Determine the unit contribution margin for each of the three products.
- 2. Provide an analysis to determine the relative product profitabilities, assuming that the reactor is a bottleneck.
- 3. Assume that management wishes to improve profitability by increasing prices on selected products. At what price would ethylene and butane need to be offered in order to produce the same relative profitability as ester?
I hope that is enough information to make a determination.
Thank you,
11 years ago
20
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

- answer.zip
Bids(1)