A hardware company sells a lot of low-cost, high- volume products. For one such product, it...

A hardware company sells a lot of low-cost, high- volume products. For one such product, it is equally likely that annual unit sales will be low or high. If sales are low (60,000), the company can sell the product for $10 per unit. If sales are high (100,000), a competitor will enter and the company will be able to sell the product for only $8 per unit. The variable cost per unit has a 25% chance of being $6, a 50% chance of being $7.50, and a 25% chance of being $9. Annual fixed costs are $30,000.

Use simulation to estimate the company’s expected annual profit. To do this set up your spreadsheet so that all the calculations for a replication are in one row as shown below (for example):

Replication #	Sales	.....	Profit
1
2
:
:
100

Use rand() to generate values for all the uncertain quantities in this situation. Once you have done all 100 replications, freeze your spreadsheet by doing Copy/Paste (Values) on the cells with the uncertain quantities – otherwise any cell that depends on rand() will keep changing.

What is the average annual profit? What is the standard deviation of profit?
Construct a frequency histogram for profit. Comment on this histogram. Your chart should be clear to anyone who reads it.
Now suppose that annual unit sales, variable cost, and unit price are equal to their respective expected values—that is, there is no uncertainty. Determine the company’s annual profit for this scenario.
Can you conclude from the results in parts (b) and (d) that the expected profit from a simulation is equal to the profit from the scenario where each input assumes its expected value? Explain.

Expert Solution

orchestra answered 1 year ago

Q: Philips Company manufactures a variety of high- and low-volume products, including product 456, in its...

Q: Philips Company manufactures a variety of high- and low-volume products, including product 456, in its Westchester Plant. The following information pertains to the most recent year: Total for product 456 Total for Westchester Unit-level overhead $200,000 Batch-level overhead 300,000 Product-level overhead 500,000 Plant-level overhead 400,000 Total overhead $1,400,000 Units produced 100 5,000 Direct labor hours 200 20,000 Machine hours 90 10,000 Setups 6 120 Setup hours 30 500 Design changes 4 40 Design hours 280 4,000 REQUIRED: (1) If...

What is generally true about overhead allocation to high-volume products versus low-volume products under a traditional...

What is generally true about overhead allocation to high-volume products versus low-volume products under a traditional costing system?

Scottsdale Ltd. manufactures a variety of high-volume and low-volume products to customer demand. Presented is information...

Scottsdale Ltd. manufactures a variety of high-volume and low-volume products to customer demand. Presented is information on 2009 manufacturing overhead and activity cost drivers. Level Total Cost Units of Cost Driver Unit $600,000 20,000 machine hours Batch 200,000 1,000 customer orders Product 400,000 50 products Product X1 required 3,000 machine hours to fill 10 customer orders for a total of 8,000 units. (a) Assuming all manufacturing overhead is estimated and predicted on the basis of machine hours, determine the predicted...

Maetins Ltd. manufactures a variety of high-volume and low-volume products to customer demand. Presented is information...

Maetins Ltd. manufactures a variety of high-volume and low-volume products to customer demand. Presented is information on 2009 manufacturing overhead and activity cost drivers. Level Total Cost Units of Cost Driver Unit $300,000 20,000 machine hours Batch 300,000 1,000 customer orders Product 100,000 50 products Product X1 required 2,000 machine hours to fill 10 customer orders for a total of 8,000 units. (a) Assuming all manufacturing overhead is estimated and predicted on the basis of machine hours, determine the predicted...

Cost-Volume-Profit (CVP) Relationships Bilco Fabrication manufactures one product, a low-cost car battery. Cost analysis by the...

Cost-Volume-Profit (CVP) Relationships Bilco Fabrication manufactures one product, a low-cost car battery. Cost analysis by the accounting department has determined that the variable cost per unit is $12. Bilco’s fixed costs amount to $792,480 annually. The company is projecting data based on a sales price of $20. Use the above data to answer the following: * Calculate Bilco’s break-even point in number of units. * Figure the level of sales that Bilco would have to achieve to reach a target...

A company sells only two products, Product A and Product B, and has the following cost...

A company sells only two products, Product A and Product B, and has the following cost information: Selling price per unit – Product A $4 Selling price per unit – Product B $5 Variable cost per unit – Product A $2 Variable cost per unit – Product B $3 Total fixed costs $840 The company sells two units of Product A for each unit it sells of Product B. The company faces an income tax rate of 30%. A) What is the breakeven point in...

Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high...

Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high and low use of three different resources for Wilson Trucking occurred in July and April. The resources are truck depreciation, fuel, and truck maintenance. The number of kilometres travelled is the driver. The total costs of the three resources and the related number of truck kilometres are as follows: Resource Truck Kilometres Total Cost ($) Truck depreciation: High 46,000,000 2,800,000 Low 32,400,000 2,800,000 Fuel:...

Select the incorrect statement regarding cost-volume-profit relationships for multiple products. For a company that sells many...

Select the incorrect statement regarding cost-volume-profit relationships for multiple products. For a company that sells many different products, the level of the break-even point is affected by the company's sales mix. An increase in sales volume accompanied by a change in sales mix could cause a company's profits to decrease. For a multi-product company, cost-volume-profit analysis can be done using the contribution margin ratio of the most profitable product. None of these answers is correct. Which of the following statements...

A company produces and sells one product only, Peperoni, the standard cost for one unit being...

A company produces and sells one product only, Peperoni, the standard cost for one unit being as Follows. $ Direct material A – 10 kilograms at $20 per kg 200 Direct material B – 5 litres at $6 per litre 30 Direct wages – 5 hours at $6 per hour 30 Fixed production overhead 50 Total standard cost 310 The fixed overhead included in the standard cost is based on an expected monthly output of...

Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to...

Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to Estimate Variable and Fixed Costs Located on Swiftcurrent Lake in Glacier National Park, Many Glacier Hotel was built in 1915 by the Great Northern Railway. In an effort to supplement its lodging revenue, the hotel decided in 20X1 to begin manufacturing and selling small wooden canoes decorated with symbols hand painted by Native Americans living near the park. Due to the great success of...

Question