1.
Calculate the number of additional direct labor hours (DLHs) that will be required each month to fill the Company G’s order.
1.
Explanation of Solution
Calculate the number of additional direct labor hours (DLHs):
Note: The standard direct labor hour (DLH) per finished valve is ½ hour.
2.
Prepare an analysis showing the impact on operating income of accepting the Company’s order.
2.
Explanation of Solution
Prepare an analysis showing the impact on operating income of accepting the Company’s order.
Particulars | Per unit | Total for 120,000 units |
Incremental revenue (a) | $ 21.00 | $ 2,520,000 |
Incremental costs | ||
Variable costs: | ||
Direct materials | 6 | 720000 |
Direct labor | 8 | 960,000 |
Variable | 3 | 360,000 |
Total variable costs | $ 17 | $ 2,040,000 |
Fixed overhead: | ||
Supervisory and clerical costs | 48,000 | |
Total incremental costs (b) | $ 2,088,000 | |
Incremental operating income (loss) | $ 432,000 |
Table (1)
3.
Calculate the minimum unit price that Company W could accept for the company G’s order without reducing operating income.
3.
Explanation of Solution
The least unit selling price that Company W could accept without decreasing operating income equals a price that covers variable costs plus the additional fixed costs. In this case, there are no opportunity costs. The $30.00 suggested selling price is irrelevant for the special order:
Particulars | Amounts in ($) |
Incremental variable costs, per unit: | |
Direct materials | $ 6.00 |
Direct labor | $ 8.00 |
Variable overhead | $ 3.00 |
Additional fixed cost | 0.4 |
Minimum selling price per unit | $ 17.40 |
Table (2)
4.
Calculate the minimum unit selling price using the Goal Seek function in Excel for the special sales order and prove the answer of requirement 3.
4.
Explanation of Solution
Calculate the minimum unit selling price using the Goal Seek function in Excel for the special sales order and prove the answer of requirement 3:
Step: 1 set up the equation:
Particulars | Per unit | Total for 120,000 units |
Four month volume (units) | $ 21.00 | $ 120,000 |
Selling per unit | ||
Incremental revenue, special sales order | $ 0 | |
Incremental costs: | ||
Variable per unit | 17 | |
Total Variable | $ 2,040,000 | |
Total fixed | 48,000 | |
Opportunity cost | 0 | |
Total incremental costs full order | $ 2,088,000 | |
Incremental operating income (loss) | $ -2,088,000 |
Table (3)
Workings:
Special order characteristics | |
# of units | 120,000 |
offer price (per unit) | $ 21 |
Cost data pressure value: | |
Direct material (per unit) | $ 6 |
Direct labor: | |
Hours per unit | 0.5 |
DL cost per unit | $ 8 |
Manufacturing overhead per unit | $ 9 |
% of overhead that is variable | 33.33% |
Additional fixed | |
Per month charge | $ 12,000 |
Duration (# of months) | 4 |
Table (4)
Table (5)
Step 2: Run the goal seek as follows:
In excel go to data tab and select what if analysis, then select Goal seek rom the drop down menu. Then select the respective values as follows:
Figure (1)
After selecting click ok.
Figure (2)
Step 2: Result:
Then the result will be as follows:
Table (6)
5.
Calculate the revised breakeven selling price per unit for G Company’s special sales order.
5.
Explanation of Solution
The minimum unit price that Company W could accept without reducing operating income must cover all incremental costs: variable, fixed, and opportunity costs.
Particulars | Per unit | Amounts in ($) |
Incremental variable cost/unit: | ||
Direct materials | $ 6.00 | |
Direct labor | $ 8.00 | |
Variable overhead | $ 3.00 | $ 17.00 |
Incremental fixed costs/unit ($48,000 ÷ 120,000 units) | 0.4 | |
Minimum selling price per unit (a) | $ 17.40 | |
Opportunity cost, per unit: | ||
Total lost sales (in units) (4 × 5,000 units) | 20,000 | |
Regular selling price per unit | $ 30.00 | |
Less: variable costs (per unit): | ||
Direct materials | $ 6.00 | |
Direct labor | $ 8.00 | |
Variable manufacturing overhead | $ 3.00 | |
Sales commissions (5% of sales $) | $ 1.50 | |
Freight charge (per unit) | $ 1.00 | |
Total variable cost per unit | $ 19.50 | |
CM per unit, regular sales | $ 10.50 | |
Total lost CM (20,000 units | $ 210,000 | |
Divide by: Four month units | 120,000 | |
Lost CM per unit of special sales order (b) | 1.75 | |
Minimum selling price per unit | $ 19.15 |
Table (7)
6.
Identify the strategic factors that the company should consider before accepting the order.
6.
Explanation of Solution
The following factors should be considered before accepting the order:
- The special order’seffect on sales at regular prices.
- The impact on local, state, and federal taxes.
- The company's “relevant range” of activity and whether the special order will cause volume to exceed this range.
- The likelihood of future sales and the effects of participating in the international marketplace.
- The effect on machinery.
- The strategic benefit of the long-term commitment from Company G.
- The firm that would handle warranty, repair, and service needs to be analyzed.
7.
Identify the factors related to international business that Company W should consider before accepting the Company G’s order.
7.
Explanation of Solution
- The customs duties and import and export limitations which might affect the special order and future business.
- However the special order will be completed in the relatively short time of a few months, and the foreign exchange rates might change considerably in this period. Hence, the special order agreement regarding the sales price needs to be analyzed.
- If Company W is not now significantly involved in global sales, then the way in which the firm might use this opportunity to increase its exposure in foreign markets needs to be described.
Want to see more full solutions like this?
Chapter 11 Solutions
Cost Management
- Financial Accounting Questionarrow_forwardWhat is the investment turnover for this financial accounting question?arrow_forwardSuppose you take out a five-year car loan for $14000, paying an annual interest rate of 4%. You make monthly payments of $258 for this loan. Complete the table below as you pay off the loan. Months Amount still owed 4% Interest on amount still owed (Remember to divide by 12 for monthly interest) Amount of monthly payment that goes toward paying off the loan (after paying interest) 0 14000 1 2 3 + LO 5 6 7 8 9 10 10 11 12 What is the total amount paid in interest over this first year of the loan?arrow_forward
- Suppose you take out a five-year car loan for $12000, paying an annual interest rate of 3%. You make monthly payments of $216 for this loan. mocars Getting started (month 0): Here is how the process works. When you buy the car, right at month 0, you owe the full $12000. Applying the 3% interest to this (3% is "3 per $100" or "0.03 per $1"), you would owe 0.03*$12000 = $360 for the year. Since this is a monthly loan, we divide this by 12 to find the interest payment of $30 for the month. You pay $216 for the month, so $30 of your payment goes toward interest (and is never seen again...), and (216-30) = $186 pays down your loan. (Month 1): You just paid down $186 off your loan, so you now owe $11814 for the car. Using a similar process, you would owe 0.03* $11814 = $354.42 for the year, so (dividing by 12), you owe $29.54 in interest for the month. This means that of your $216 monthly payment, $29.54 goes toward interest and $186.46 pays down your loan. The values from above are included…arrow_forwardSuppose you have an investment account that earns an annual 9% interest rate, compounded monthly. It took $500 to open the account, so your opening balance is $500. You choose to make fixed monthly payments of $230 to the account each month. Complete the table below to track your savings growth. Months Amount in account (Principal) 9% Interest gained (Remember to divide by 12 for monthly interest) Monthly Payment 1 2 3 $500 $230 $230 $230 $230 + $230 $230 10 6 $230 $230 8 9 $230 $230 10 $230 11 $230 12 What is the total amount gained in interest over this first year of this investment plan?arrow_forwardGiven correct answer general Accounting questionarrow_forward
- On 1st May, 2024 you are engaged to audit the financial statement of Giant Pharmacy for the period ending 30th December 2023. The Pharmacy is located at Mgeni Nani at the outskirts of Mtoni Kijichi in Dar es Salaam City. Materiality is judged to be TZS. 200,000/=. During the audit you found that all tests produced clean results. As a matter of procedures you drafted an audit report with an unmodified opinion to be signed by the engagement partner. The audit partner reviewed your file in October, 2024 and concluded that your audit complied with all requirements of the international standards on auditing and that; sufficient appropriate audit evidence was in the file to support a clean audit opinion. Subsequently, an audit report with an unmodified opinion was issued on 1st November, 2024. On 18th January 2025, you receive a letter from Dr. Fatma Shemweta, the Executive Director of the pharmacy informing you that their cashier who has just absconded has been arrested in Kigoma with TZS.…arrow_forwardNonearrow_forwardNeed help this questionarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education