Structuring a Make-or-Buy Problem
Fresh Foods, a large restaurant chain, needs to determine if it would be cheaper to produce 5,000 units of its main food ingredient for use in its restaurants or to purchase them from an outside supplier for $12 each. Cost information on internal production includes the following:
| Total Cost | Unit Cost | ||
| Direct materials | $25,000 | $5.00 | |
| Direct labor | 15,000 | 3.00 | |
| Variable manufacturing overhead | 7,500 | 1.50 | |
| Variable marketing overhead | 11,000 | 2.20 | |
| Fixed plant overhead | 30,000 | 6.00 | |
| Total | $88,500 | $17.70 |
Fixed overhead will continue whether the ingredient is produced internally or externally. No additional costs of purchasing will be incurred beyond the purchase price. If required, round your answers to the nearest whole number.
Required:
1. What are the alternatives for Fresh
Foods?
2. List the relevant cost(s) of internal production and of external purchase.
3. Which alternative is more cost effective and by how much? (Use total cost when giving your answer.)
| $ |
4. Now assume that 20% of the fixed overhead can be avoided if the ingredient is purchased externally. Which alternative is more cost effective and by how much? (Use total cost when giving your answer.)
| $ |
In: Accounting
Cox Electric makes electronic components and has estimated the following for a new design of one of its products:
Fixed Cost = $3,000
Material cost per unit = $0.15
Labor cost per unit = $0.10
Revenue per unit = $0.65
Production Volume = 12,000
Per-unit material and labor cost together make up the variable cost
per unit. Assuming that Cox Electric sells all it produces, build a
spreadsheet model that calculates the profit by subtracting the
fixed cost and total variable cost from total revenue, and answer
the following questions.
| a) | Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? |
| ____to____ units |
| (b) | Use Goal Seek to find the exact breakeven point. Assign Set cell: equal to the location of profit, To value: = 0, and By changing cell: equal to the location of the production volume in your model. |
In: Statistics and Probability
Cox Electric makes electronic components and has estimated the following for a new design of one of its products:
Fixed Cost = $15,000
Material cost per unit = $0.15
Labor cost per unit = $0.10
Revenue per unit = $0.65
Production Volume = 12,000
Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build a spreadsheet model that calculates the profit by subtracting the fixed cost and total variable cost from total revenue, and answer the following questions.
| (a) | Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? |
| to units | |
| (b) | Use Goal Seek to find the exact breakeven point. Assign Set cell: equal to the location of profit, To value: = 0, and By changing cell: equal to the location of the production volume in your model. |
In: Finance
Cost functions, a part of the definition of profit, are useful to gauge the performance of the business. Suppose an economist estimated that the cost function of a single-product firm as: C(Q) = 2 + 2Q + 2Q2 Based on this information, determine the followings and show all steps (first, you must define each of the terms in the cost function, and then plug in the numbers to have your answers; not just the answers): Hint: The use of Graphs is recommended. a. Define fixed cost and offer an example. Next, compute the fixed cost of producing 4 units of output using the cost function above. b. Define variable cost and offer an example. Next compute the variable cost of producing 4 units of output using the cost function above. c. Define total cost and then compute the total cost of producing 4 units of output using the cost function above d. Define and compute the average fixed cost of producing 10 units of output e. Define and compute the average variable cost of producing 10 units of output f. Define and compute the average total cost of producing 10 units of output g. Define marginal cost an offer an example. Next, compute the marginal cost when Q = 2, using the cost function above
In: Economics
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
|
Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,761,600 | |
| Cost of goods sold | 1,235,745 | ||
| Gross margin | 525,855 | ||
| Selling and administrative expenses | 620,000 | ||
| Net operating loss | $ | (94,145 | ) |
Hi-Tek produced and sold 60,300 units of B300 at a price of $21 per unit and 12,700 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,000 | $ | 162,000 | $ | 562,000 |
| Direct labor | $ | 121,000 | $ | 42,300 | 163,300 | |
| Manufacturing overhead | 510,445 | |||||
| Cost of goods sold | $ | 1,235,745 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $56,000 and $104,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 201,085 | 90,900 | 62,600 | 153,500 | |
| Setups (setup hours) | 148,260 | 73 | 280 | 353 | ||
| Product-sustaining (number of products) | 100,600 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,500 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 510,445 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
2.
ompute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
3.
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
ABC hotel has 200 rooms and has a policy to determine its room rates based on consumers capacity to pay. For example busniess clients pay $1,200 per night and group tours $900 per night. The incremental cost of servicing a room is worked out at $110 per room. On average, most guest stay for three (3) nights. Rooms division manager is trying to establish if four (4) week advance reservation should be taken for a group booking of 40 rooms and three (3) nights of 7th , 8th and 9th June 2018. According to the reservation record, 80 rooms for the three (3) nights of 7th , 8th , and 9th , June 2018 are already booked by various business clients, and the historical trends of the past four (4) years suggest that 90% of the remaing 120 rooms would be sold to other busniess clients. Your are required to b) In the highly competitive environment, tourism and hospitality busniess can aspire to optimise revenue for the long term survival. Discuss " one pricing strategy " and its effect on tourism and hospitality businesses as a whole focus on the pricing strategy in tourism and hospitality business and highlight their strengths and weaknesses as reported in the published literature.
In: Accounting
In accordance with the current Conceptual Framework, define liability as one of the five elements of the statutory financial statements and outline its recognition criteria.
Further, explain whether or not you would recognise each of the following independent items as a liability, by reference to the abovementioned liability definition and recognition criteria:
In: Accounting
Your company, XYZ, Inc., wants to create an outdoor area adjacent to its office building for its employees to enjoy during lunch, breaks or during non-business hours.The city, Village Township, has restrictions of the use of the land (zoning) and the type of structures that may be erected on the land. The plans that your company have created is in violation of the city ordinances. Your company does not want to spend a lot of money to resolve negotiate with the city regarding the ordinance problem because the plans and cost of building the park are over budge. You are in charge of helping find a resolution for this conflict with the city. You report directly to the CEO of XYZ, Inc., and she has asked you to research whether arbitration, mediation or litigation would be in the best interest of both parties to resolve this conflict.
In: Operations Management
Problem 5-16 (Algo) Comparing Traditional and Activity-Based Product Margins [LO5-1, LO5-3, LO5-4, LO5-5]
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,709,200 | |
| Cost of goods sold | 1,257,251 | ||
| Gross margin | 451,949 | ||
| Selling and administrative expenses | 560,000 | ||
| Net operating loss | $ | (108,051 | ) |
Hi-Tek produced and sold 60,500 units of B300 at a price of $20 per unit and 12,800 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,300 | $ | 162,900 | $ | 563,200 |
| Direct labor | $ | 120,400 | $ | 42,400 | 162,800 | |
| Manufacturing overhead | 531,251 | |||||
| Cost of goods sold | $ | 1,257,251 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $59,000 and $100,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 212,531 | 90,500 | 62,400 | 152,900 | |
| Setups (setup hours) | 157,520 | 78 | 280 | 358 | ||
| Product-sustaining (number of products) | 100,400 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,800 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 531,251 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
2.Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The following information describes the costs for a firm in a perfectly competitive market. Fill in the cells (4 points) then answer the questions that follow.
|
Quantity |
Variable Cost |
Fixed Cost |
Total Cost |
Average Variable Cost |
Average Total Cost |
Marginal Cost |
|
0 |
0 |
$300 |
-- |
|||
|
1 |
$110 |
|||||
|
2 |
$190 |
|||||
|
3 |
$250 |
|||||
|
4 |
$360 |
|||||
|
5 |
$510 |
|||||
|
6 |
$685 |
|
In: Economics