Please solve Problem 3-11 from your textbook (Introduction to Managerial Account
ID: 2431276 • Letter: P
Question
Please solve Problem 3-11 from your textbook (Introduction to Managerial Accounting; Fifth Canadian Edition, by Brewer, Garrison, Noreen, Kalagnanam, and Vaidyanathan) considering the following new information and requirements:
The company received a request for a 300-Kg order of potassium aspartate.
The customer offers to pay $12.50per Kg for this order.
The company usually adds a 30%markup for this type of orders.
Material requirements
Material
Required Quantity (per Kg)
Price ($) per Kg
Aspartic Acid
190.00
5.75
Citric Acid
10.00
2.00
K2CO3
120.00
4.50
Rice
30.00
.50
The company pays its production workers an average of $20.00per hour plus $5.00per hour additional labour costs.
Expected direct labour time was 16 hours.
The company also estimated the following:
Materials related overhead
$585,000
Labour related overhead
$1,950,000
Direct material costs
$1,850,000
Direct labour cost
$1,250,000
Prepare a job cost sheet for the proposed job. Ignore the job completion status area. (9 points)
What is the total expected cost of this order? (1 point)
What is the unit (per Kg) cost of this order? (1 point)
Should the company accept the price offered by the customer? (1 point) Please explain showing all your calculations. (3 points).
What is the gross margin expressed in %, if the customer agrees to pay a price of cost plus 25%? (1 point). Please show all your calculations. (1 point)
What is the total gross margin per total order (expressed in dollar amount) (1 point). Please clearly show all you calculations. (1 point)
What is the gross margin per unit (per Kg) (expressed in dollar amount). (1 point) Please clearly show all your calculations. (1 point)
Assume that the actual production level was only 280 Kg despite using the expected quantity of materials and labour. What is the gross margin of this order: percentage-wise (1 point), total gross margin per order (dollar amount)(1 point), gross margin per unit (per Kg)(dollar amount)(1 point). Please clearly show all you calculations. (1 point)
Material
Required Quantity (per Kg)
Price ($) per Kg
Aspartic Acid
190.00
5.75
Citric Acid
10.00
2.00
K2CO3
120.00
4.50
Rice
30.00
.50
Explanation / Answer
Solution a:
Pre determined overhead rate:
Material related overhead = $585,000 / $1,850,000 = 31.62% of direct material cost
Labor related overhead = $1,950,000 / $1,250,000 = 156% of direct labor cost
Solution b:
Total expected cost of order = $3,218.76
Solution c:
Unit (per Kg) cost of this order = $3,218.76 / 300 = $10.73 per kg
Solution d:
Required selling price considering 30% markup = $10.73 + 30% of $10.73 = $13.95 per Kg
Price offered by customer = $12.50 per Kg
As price offered by customer is lesser than minimum required price therefore company should not accept price offered by customer.
Solution e:
If customer agree to pay cost + 25% then
Let cost = $100
Selling price = $125
Gross margin = $125 - $100 = $25
Gross margin percentage = $25 / $125 = 20%
Note: I have answered more than required parts as per chegg policy, kindly post separate question for answer of remaining parts.
Job Cost Sheet Particulars Amount Direct material: Aspartic Acid (190 * $5.75) $1,092.50 Citric Acid (10*$2) $20.00 K2CO3 (120 * $4.50) $540.00 Rice (30*$0.50) $15.00 Total direct material cost $1,667.50 Direct labor (16*$25) $400.00 Overhead applied: material related (31.62% of direct material cost) $527.26 Labor related overhead (156% of direct labor cost) $624.00 Total overhead applied $1,151.26 Total expected cost of order $3,218.76