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 | 10,000 | 2.00 | |
| Fixed plant overhead | 30,000 | 6.00 | |
| Total | $87,500 | $17.50 |
Fixed overhead will continue whether the ingredient is produced internally or externally. No additional costs of purchasing will be incurred beyond the purchase price.

Structuring a Make-or-Buy Problem Fresh Foods, a large restaurant chain, needs to determine if it would...
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 8,000 1.60 Fixed plant overhead 30,000 6.00 Total $85,500 ...
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,500 2.30 Fixed plant overhead 30,000 6.00 Total $89,000 ...
Fresh foods needs to determine if it would be cheaper to produce 5,000 units of its main food ingredient in house or to purchase them from a supplier for $12 each. Cost information on internal production includes the following: Assume that fixed overhead will continue whether the ingredient is produced internally or externally. Which alternative is more cost effective and by how much? Now assume that 20% of the fixed overhead can be avoided if the ingredient is purchased externally....
Prepare a make or buy analysis. XUS Prepare a make or buy analysis - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri -11-AA Paste B IU, L - A Alignment Number Conditional Format as Cell Cells Formatting* Table Styles - Clipboard Font El Styles A1 X for Alanco, Inc. manufactures a variety of products and is currently maunfacturing all A B C D E HI Alanco, Ind. manufactures a variety of products...
Maggie Dakis is a senior buyer of fruit products for Fresh Foods, a major United States (U.S.) multinational food processing company. This company, based in California, uses a wide variety of fruit concentrates, purees, flavors, and extracts in many of its popular food products. One of Maggie’s responsibilities is to negotiate annual purchase contracts for these ingredients. One such ingredient, mango puree, is grown and harvested on a seasonal basis in various countries around the world. Maggie is currently examining...
Can you post the answers as a
formula?
Prepare a make or buy analysis. ? X - Sign In FILE Prepare a make or buy analysis - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -11 TA À B I U - - A - Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles Paste Cells Editing Clipboard A1 V : * fic of its own component parts. A B C D E F G Hн...
Structuring a Special-Order Problem Harrison Ford Company has been approached by a new customer with an offer to purchase 10,000 units of its model IJ5 at a price of $4.00 each. The new customer is geographically separated from the company's other customers, and existing sales would not be affected. Harrison normally produces 75,000 units of IJ5 per year but only plans to produce and sell 60,000 in the coming year. The normal sales price is $12 per unit. Unit cost...
Structuring a Special-Order Problem Harrison Ford Company has been approached by a new customer with an offer to purchase 10,000 units of its model IJ5 at a price of $5 each. The new customer is geographically separated from the company's other customers, and existing sales would not be affected. Harrison normally produces 75,000 units of IJ5 per year but only plans to produce and sell 60,000 in the coming year. The normal sales price is $12 per unit. Unit cost...
Make-or-Buy Decision, Alternatives, Relevant Costs Each year, Basu Company produces 13,000 units of a component used in microwave ovens. An outside supplier has offered to supply the part for $1.31. The unit cost is: Direct materials $0.89 Direct labor 0.27 Variable overhead 0.07 Fixed overhead 2.10 Total unit cost $3.33 Required: 1. What are the alternatives for Basu Company? Make the part in house or buy the part externally 2. Assume that none of the fixed cost is avoidable. List...
Structuring a Special-Order Problem Recently Wang Company was been approached by a new customer with an offer to purchase 10,000 units of its model I34 at a price of $4.55 each. The new customer is geographically separated from the company's other customers, and existing sales would not be affected. Normally Wang Company produces 75,000 units of I34 per year but only plans to produce and sell 60,000 in the coming year. The normal sales price is $12 per unit. Unit...