Question

In: Accounting

Wally’s Widget World is an online retailer that makes and sells widgets. There are three models...

Wally’s Widget World is an online retailer that makes and sells widgets. There are three models of widgets, each with its own cost of materials and labor.

Model	Percent of sales	Materials cost	Labor cost	Selling price
Econowidget – base-level widget for the budget-conscious widget user	35%	$3.50	$1.50	$6.99
Superwidget – adds additional feature for the more demanding widget user	45%	$4.00	$1.75	$8.99
Widget Supreme – for the more discerning and sophisticated widget user	20%	$5.25	$2.00	$11.99

The widgets are all the same size and approximate weight, so shipping costs for each widget (regardless of model) are $2.50, and customers are charged $3.99 per widget. Wally’s Widget World has monthly costs below:

Rent                   $10,000
Utilities              2,000
Administrative salaries     6,000
Overhead/supplies      1,000

In addition, Wally’s budgets $3,000 each month on banner ads and search-engine marketing. Assuming the percentage of sales for each product in the product line remains constant, perform the following analyses:

Calculate the break-even volume

Calculate the break-even revenue

Wally’s Widget World has a monthly target profit of $5,000. What should be the target volume and revenue for this objective?

Is this a viable target profit? Explain using your calculations. Give an example of another target profit that you think would work and explain why

Expert Solution

Particulars	Econowidget	Superwidget	Widget supreme
Selling price	6.99	8.99	11.99
Add:Shipping charges	3.99	3.99	3.99
Total	10.98	12.98	15.98
Less:
Shipping cost	2.5	2.5	2.5
Material cost	3.5	4	5.25
Labour cost	1.5	1.75	2
Contribution	3.48	4.73	6.23
PV Ratio = contribution/Selling price	31.7	36.4	39.0
Percent of sales	35%	45%	20%
Combined PV Ratio	11.1	16.4	7.8
Total PV Ratio	(11.1+16.4+7.8)	35.3

Total fixed cost

Rent 10000

Utilities 2000

Administrative salary 6000

Total fixed cost 18000

Break even Revenue =Fixed cost/Combined PV Ratio
(18000/35.3%)
50992
Break even Volume
		Break even volume per each widget
Econowidget 35%	(50992*35%)/10.98	1625
Superwidget 45%	(50992*45%)/12.98	1768
Widget supreme 20%	(50992*20%)/15.98	638

Target volume and revenue if there is 5000 profit
Revenue =Fixed cost+Profit/Combined PV Ratio
(18000+5000/35.3%)
65156
Volume
		volume per each widget
Econowidget 35%	(65156*35%)/10.98	2077
Superwidget 45%	(65156*45%)/12.98	2259
Widget supreme 20%	(65156*20%)/15.98	815

Profit	5000
Less:Banner advertisement	3000
Less:Overhead	1000
Balance profit	1000

Therefore the profit or 5000 is viable

ekkarill92 answered 1 year ago

a widget manufacturing company makes big widgets and small widgets. Each widget must processed in a...

a widget manufacturing company makes big widgets and small widgets. Each widget must processed in a wood shop and in a paint shop. It takes 480 minutes of process time per work day per shop. If the paint shop paints only small widgets, then 60 can be painted per day. If the paint shop paints large widgets only then 40 can be painted per day. If the wood shop only process large widgets only then it could process 50 widgets...

A manufacturing business makes and sells widgets. Each widget requires two units of raw materials, which...

A manufacturing business makes and sells widgets. Each widget requires two units of raw materials, which cost $3 each. Production and sales quantities of widgets each month are as follows: Month Sales and production units December (actual) 50,000 January (budget) 55,000 February (budget) 60,000 March (budget) 65,000 In the past, the business has maintained its inventories of raw materials at 100,000 units. However, it plans to increase raw material inventories to 110,000 units at the end of January and 120,000...

A manufacturing business makes and sells widgets. Each widget requires two units of raw materials which...

A manufacturing business makes and sells widgets. Each widget requires two units of raw materials which costs $3.00 each. Production and sales quantities of widgets each month are as follows: Month Sales and Production December (Actual) 50,000 units January (Budget) 55,000 units February (Budget) 60,000 units March (Budget) 65,000 units In the past the business has maintained its inventories of raw materials at 100,000 units. However, it plans to increase raw materials inventories to 110,000 units at the end of...

A manufacturer of two products (Widgets and Gadgets) makes a profit of $180 for each widget...

A manufacturer of two products (Widgets and Gadgets) makes a profit of $180 for each widget sold and $180 for each gadget sold. However, production of these products generates hazardous waste charges at the rate of 3W2 (where W is the number of Widgets produced) and 2G2 (where G is the number of Gadgets produced). The manufacturer has ample supplies of all raw materials and can sell all the Widgets and Gadgets it produces. The firm has sufficient capacity to...

A manufacturer of two products (Widgets and Gadgets) makes a profit of $110 for each widget...

A manufacturer of two products (Widgets and Gadgets) makes a profit of $110 for each widget sold and $100 for each gadget sold. However, production of these products generates hazardous waste charges at the rate of 1W2 (where W is the number of Widgets produced) and 3G2 (where G is the number of Gadgets produced). The manufacturer has ample supplies of all raw materials and can sell all the Widgets and Gadgets it produces. The firm has sufficient capacity to...

D & B Enterprises is a cah basis taxpayer who makes widgets. It sell the widget...

D & B Enterprises is a cah basis taxpayer who makes widgets. It sell the widget for $500,000 in gross receips through December 2012. The company also received $200,000 from a life insurance policy that it received after the death of Russell, it's chief financial officer. Then on December 28, it recives payment in the amount of $100,000 for an order of widgets which it sent to the customer on December 20. Avon, the CEO, cashes the check on January...

Mr. Gold is in the widget business. He currently sells 1.7 million widgets a year at...

Mr. Gold is in the widget business. He currently sells 1.7 million widgets a year at $8 each. His variable cost to produce the widgets is $6 per unit, and he has $1,570,000 in fixed costs. His sales-to-assets ratio is eight times, and 40 percent of his assets are financed with 12 percent debt, with the balance financed by common stock at $10 par value per share. The tax rate is 40 percent. His brother-in-law, Mr. Silverman, says Mr....

Mr. Gold is in the widget business. He currently sells 1.1 million widgets a year at...

Mr. Gold is in the widget business. He currently sells 1.1 million widgets a year at $5 each. His variable cost to produce the widgets is $3 per unit, and he has $1,620,000 in fixed costs. His sales-to-assets ratio is five times, and 20 percent of his assets are financed with 12 percent debt, with the balance financed by common stock at $10 par value per share. The tax rate is 40 percent. His brother-in-law, Mr. Silverman, says he...

The demand for widgets has been determined to be 10,000 per year. Each widget sells for...

The demand for widgets has been determined to be 10,000 per year. Each widget sells for $4.00 and costs $2.25 to produce. Using breakeven analysis and an interest rate of 12%, determine the maximum purchase price that could be paid for the required machinery. The machine is expected to last 8 years and to have a salvage value of 5% of the purchase price. Please show the answer in excel if possible

Mr. Gold is in the widget business. He currently sells 2.0 million widgets a year at...

Mr. Gold is in the widget business. He currently sells 2.0 million widgets a year at $6 each. His variable cost to produce the widgets is $4 per unit, and he has $1,710,000 in fixed costs. His sales-to-assets ratio is six times, and 30 percent of his assets are financed with 13 percent debt, with the balance financed by common stock at $10 par value per share. The tax rate is 40 percent. His brother-in-law, Mr. Silverman, says he...