You have this assortment of products. Calculate the weighted sales price, weighted variable cost, and weighted profit. You also had an investment in fixtures of $15,000.
Homework Answers
- Computation of weighted sales price:
|
Product |
Sales units |
proportion |
|
A |
1,500 |
8.33% |
|
B |
2,000 |
11.11% |
|
C |
3,500 |
19.44% |
|
D |
5,000 |
27.78% |
|
E |
6,000 |
33.33% |
|
Total |
18,000 |
100% |
Weighted sales price = ($14.99 x 8.33%) + ($18.99 x 11.11%) + ($25 x 19.44%) + (15.99 x 27.78%) + (17.99 x 33.33%)
Weighted sales price per unit = $18.66
- Computation of weighted variable cost:
Weighted variable cost = ($8 x 8.33%) + ($10 x 11.11%) + ($15 x 19.44%) + ($7 x 27.78%) + ($8 x 33.33%)
Weighted variable cost per unit = $9.30
- Weighted profit:
|
Product |
sales price |
Sales units |
proportion |
Variable cost |
Profit |
|
A |
$14.99 |
1,500 |
8.33% |
$8 |
$6.99 |
|
B |
$18.99 |
2,000 |
11.11% |
10 |
$8.99 |
|
C |
$25 |
3,500 |
19.44% |
$15 |
$10 |
|
D |
$15.99 |
5,000 |
27.78% |
$7 |
$8.99 |
|
E |
$17.99 |
6,000 |
33.33% |
$8 |
$9.99 |
|
Total |
18,000 |
100% |
Weighted profit = ($6.99 x 8.33%) + ($8.99 x 11.11%) + (10 x 19.44%) + ($8.99 x 27.78%) + ($9.99 x 33.33%)
Weighted profit = $9.35
Add Answer to:
You have this assortment of products. Calculate the weighted
sales price, weighted variable cost, and weighted...
in an excel format, can you please solve the following! thanks! Calculate the weighted Average Cost...
in
an excel format, can you please solve the following!
thanks!
Calculate the weighted Average Cost of Capital Given Rate Below (60 points) Show Work Cost of Capital Weighted Average Bonds Preferred Stock Internal Equity Common Stock % of Equity 25.00% 10.00% 10.00% 55.00% Remember Flotation Costs and Taxes Par Value Market Price Flotation Costs Coupon Rate Maturity $1.001.00 $1.100.00 S100.00 X% 10 years Tax Rate 30.01% Preferred Stock Remember Flotation Costs Dividend Selling Price Flotation Costs $6.00 S85 0...
Our company manufactures bird feeders. The budgeted sales price is $30 per unit, and the variable...
Our company manufactures bird feeders. The budgeted sales price is $30 per unit, and the variable costs are $12 per unit. Budgeted fixed costs for the company are $15,000 What is the budgeted amount for contribution margin for 5,000 bird feeders? a. $18 per unit b. $90000 c.$75000 d.$60000 The static budget for our company shows a sales volume of 2,000 units and a sales price of $60 per unit. Actual sales for the year totaled 2,100 units, and the...
. Did variable selling cost per unit figure into any of your calculations? Which ones, if...
. Did variable selling cost per unit figure into any of your calculations? Which ones, if any? . Is there anything misleading about the figure given for fixed manufacturing overhead? . What is the significance of contribution margins with respect to determining how much of each product to produce to maximize profit? What is the significance of contribution margins with respect to determining how much Rutro should pay for additional machine time? Why isn't sales price or the difference between...
Problem 8-04 (Algorithmic) Lawn King manufactures two types of riding lawn mowers. One is a low-cost...
Problem 8-04 (Algorithmic) Lawn King manufactures two types of riding lawn mowers. One is a low-cost mower sold primarily to residential home owners; the other is an industrial model sold to landscaping and lawn service companies. The company is interested in establishing a pricing policy for the two mowers that will maximize the gross profit for the product line. A study of the relationships between sales prices and quantities sold of the two mowers has validated the following price-quantity relationships....
Exercise 2-13 (Algo) Changes in Selling Price, Sales Volume, Variable Cost per Unit, and Total Fixed...
Exercise 2-13 (Algo) Changes in Selling Price, Sales Volume, Variable Cost per Unit, and Total Fixed Costs [LO2-1, LO2-4] Miller Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (32,000 units) $ 320,000 $ 10.00 Variable expenses 224,000 7.00 Contribution margin 96,000 $ 3.00 Fixed expenses 50,000 Net operating income $ 46,000 Required: (Consider each case independently): 1. What is the revised net operating income if unit sales increase by 19%? 2....
SALES PRICt/UNIT VAR COST/UNIT FIXED COST 100 1,000,000 How MANY UNITS HAVE TO BE SOLD IN ORDER FOR NIBT TO 50% OF GROSS PROFI PRODUCTS PER UNIT SALES PRICE PER UNIT VARIABLE COST PER UNIT GP PER...
SALES PRICt/UNIT VAR COST/UNIT FIXED COST 100 1,000,000 How MANY UNITS HAVE TO BE SOLD IN ORDER FOR NIBT TO 50% OF GROSS PROFI PRODUCTS PER UNIT SALES PRICE PER UNIT VARIABLE COST PER UNIT GP PER UNIT FIXED COST PER UNIT NIBT 10 8 2 10 10 -2 WHICH PRODUCT OR PRODUCTS (IF ANY) NEEDS/ NEED TO BE REMOVED TO MAXIMIZE PROFIT (FIXED COST IS NOT ELIMINATED IF AN ITEM IS ELIMINATED)
SALES PRICt/UNIT VAR COST/UNIT FIXED COST 100...
For a table manufacturing company, selling price for a table is $177.00 per Unit, Variable cost...
For a table manufacturing company, selling price for a table is $177.00 per Unit, Variable cost is $29.00 per Unit, rent is $3,391.00 per month and insurance is $288.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $318.00 per Unit, Variable cost to $57.00 per Unit, bigger area will have rent $5,972.00 per month and insurance is $400.00 per month At what point will...
For a table manufacturing company, selling price for a table is $156.00 per Unit, Variable cost...
For a table manufacturing company, selling price for a table is $156.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,179.00 per month and insurance is $292.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $297.00 per Unit, Variable cost to $42.00 per Unit, bigger area will have rent $5,816.00 per month and insurance is $336.00 per month At what point will...
Show All Your Works How Do You Solve It: Calculate Sales mix and Contribution margin for...
Show All Your Works How Do You Solve It: Calculate Sales mix and Contribution margin for 256GB in Requirement 10 GigaCo Manufacturing manufactures 256GB SD cards (memory cards for mobile phones, digital cameras, and other devices). Price and cost data for a relevant range extending to 200,000 units per month are as follows: i Requirements - X Data Table - X 20.00 7.40 1. What is the company's contribution margin per unit? Contribution margin percentage? Total contribution margin? 2. What...
Situation Three Rutro Corp. makes three products in a single facility. These products have the following...
Situation Three Rutro Corp. makes three products in a single facility. These products have the following unit product costs: Product A Product B Product C Direct material $32.00 $40.00 $42.00 Direct labor 22.00 20.00 16.00 Variable manufacturing overhead 6.00 8.00 15.00 Fixed manufacturing overhead 29.00 38.00 28.00 Unit cost $89.00 $106.00 $101.00 Additional data concerning these products are listed below: Product A Product B Product C Mixing minutes...
in
an excel format, can you please solve the following!
thanks!
Calculate the weighted Average Cost of Capital Given Rate Below (60 points) Show Work Cost of Capital Weighted Average Bonds Preferred Stock Internal Equity Common Stock % of Equity 25.00% 10.00% 10.00% 55.00% Remember Flotation Costs and Taxes Par Value Market Price Flotation Costs Coupon Rate Maturity $1.001.00 $1.100.00 S100.00 X% 10 years Tax Rate 30.01% Preferred Stock Remember Flotation Costs Dividend Selling Price Flotation Costs $6.00 S85 0...
. Did variable selling cost per unit figure into any of your calculations? Which ones, if any? . Is there anything misleading about the figure given for fixed manufacturing overhead? . What is the significance of contribution margins with respect to determining how much of each product to produce to maximize profit? What is the significance of contribution margins with respect to determining how much Rutro should pay for additional machine time? Why isn't sales price or the difference between...
SALES PRICt/UNIT VAR COST/UNIT FIXED COST 100 1,000,000 How MANY UNITS HAVE TO BE SOLD IN ORDER FOR NIBT TO 50% OF GROSS PROFI PRODUCTS PER UNIT SALES PRICE PER UNIT VARIABLE COST PER UNIT GP PER UNIT FIXED COST PER UNIT NIBT 10 8 2 10 10 -2 WHICH PRODUCT OR PRODUCTS (IF ANY) NEEDS/ NEED TO BE REMOVED TO MAXIMIZE PROFIT (FIXED COST IS NOT ELIMINATED IF AN ITEM IS ELIMINATED)
SALES PRICt/UNIT VAR COST/UNIT FIXED COST 100...
For a table manufacturing company, selling price for a table is $156.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,179.00 per month and insurance is $292.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $297.00 per Unit, Variable cost to $42.00 per Unit, bigger area will have rent $5,816.00 per month and insurance is $336.00 per month At what point will...
Show All Your Works How Do You Solve It: Calculate Sales mix and Contribution margin for 256GB in Requirement 10 GigaCo Manufacturing manufactures 256GB SD cards (memory cards for mobile phones, digital cameras, and other devices). Price and cost data for a relevant range extending to 200,000 units per month are as follows: i Requirements - X Data Table - X 20.00 7.40 1. What is the company's contribution margin per unit? Contribution margin percentage? Total contribution margin? 2. What...
Most questions answered within 3 hours.
-
B. If compound Y has approximately the same values of solubility
in toluene as compound X,...
asked 42 minutes ago -
Oscar Inc. has inventory in Japan valued at 39,051,000 Yen one
year ago. One year ago...
asked 49 minutes ago -
If Canada suffered from "fundamental disequilibrium," and its
government choose not to devalue its currency, a...
asked 58 minutes ago -
4. How many input & output Key Value Pairs are passed into,
and emitted out of...
asked 53 minutes ago -
Why would your heart not function well if constructed of
skeletal muscle? What is the particular...
asked 1 hour ago -
Please respond to this essay question in full essay form for
Chemistry 1102 Organic and Biochemistry:...
asked 1 hour ago -
Determine the head loss and velocity of flow in a water supply main
of 15.0 cm...
asked 1 hour ago -
A marketing executive who knowingly authorizes a shoddy
defective product to be brought to market is...
asked 1 hour ago -
Write a psudocode:
1. Define a function called authorize that takes in 2 strings,
uName, and...
asked 1 hour ago -
What Hall voltage (in mV) is produced by a 0.180 T field applied
across a 2.60...
asked 1 hour ago -
What mass of ethylene glycol (C2H6O2) must be added to 211.0 g
of water to obtain...
asked 1 hour ago -
Mary's employer has a defined benefits retirement plan, which
pay 3.2% of her last year's salary...
asked 1 hour ago