Question

In: Accounting

Part 3 USB Inc. predicted 2018 variable and fixed costs are as follows: Company budgeted for:...

Part 3

USB Inc. predicted 2018 variable and fixed costs are as follows:

Company budgeted for:

43,200

Units

Variable costs

Fixed costs

Manufacturing

734,400

172,800

Selling and Administrative

216,000

60,500

Total

950,400

233,300

USB Inc. produces a wide variety of computer interface devices. Per unit

manufacturing cost information about one of these products, a high-capacity flash drive is as follows:

Direct material

$6

Direct labor

8

Variable Manufacturing Overhead

3

Fixed Manufacturing Overhead -allocated per unit

4

Total manufacturing costs

$21

The following is the variable selling and administrative costs for the flash drive:

$5

Management has set a 2018 target profit on the flash drive of:

$200,000

Required: Make sure you show your work or use cell references for all calculations. You will not earn credit if you just type in your answer.                                                                                                                      

1. Determine the markup percentage on total variable costs required to earn the desired profit-46%       

2. Use the variable cost markup you determined in #1 above to determine a suggested selling price for a flash drive. You are determining selling price per unit.                                                                                                                                           

                Selling price is based on total variable cost plus markup from #1 above.                                                                                                                 

                Total variable cost per unit                                                                                                          

                Markup above total Variable cost                                                                                                             

                Selling price per unit                                                                      

                                                                                                                                                                                                                                               

                                                                                                                               

                                                                                                                               

Solutions

Expert Solution

1.

Variable Costs Per unit For 43,200 units
Direct Material                       6                    259,200
Direct Labor                       8                    345,600
Variable Manufacturing OH                       3                    129,600
Variable Selling and Admininstrative expenses                       5                    216,000
Total Variable Costs                    22                    950,400
Fixed Costs                    233,300
Total Costs                 1,183,700
Desired profit                    200,000
Expected Sales                 1,383,700
Mark up % = (Desired Sales - Variable cost) / Variable cost 45.59% approx 46%

2. Selling price per unit

Variable cost per unit = $22

+Mark up (22*45.59%) = $10.03

Selling price per unit = $32.03

Notes:

Selling price per unit = 32.03

Total sales = $1,383,700


Related Solutions

Part 4 USB Inc. predicted 2018 variable and fixed costs are as follows: Company budgeted for:...
Part 4 USB Inc. predicted 2018 variable and fixed costs are as follows: Company budgeted for: 43,200 Units Variable costs Fixed costs Manufacturing 734,400 172,800 Selling and Administrative 216,000 60,500 Total 950,400 233,300 USB Inc. produces a wide variety of computer interface devices. Per unit manufacturing cost information about one of these products, a high-capacity flash drive is as follows: Direct material $6 Direct labor 8 Variable Manufacturing Overhead 3 Fixed Manufacturing Overhead -allocated per unit 4 Total manufacturing costs...
Tech Com's. predicted 2017 variable and fixed costs are as follows: Variable costs Fixed costs Manufacturing...
Tech Com's. predicted 2017 variable and fixed costs are as follows: Variable costs Fixed costs Manufacturing 480,000 315900 Selling and Administrative 216,000 60500 Total 696,000 376,400 Tech com. produces a wide variety of computer interface devices. Per unit manufacturing cost information about one of these products, a high-capacity flash drive is as follows: Direct material $10 Direct labor 9 Variable Manufacturing Overhead 7 Fixed Manufacturing Overhead 9 Total manufacturing costs $35 The following is the variable selling and administrative costs...
A company’s budgeted costs for 60,000 units are as follows: Fixed manufacturing costs $30,000 Variable manufacturing...
A company’s budgeted costs for 60,000 units are as follows: Fixed manufacturing costs $30,000 Variable manufacturing costs $15.00 per unit The company produced 50,000 units. How much is the flexible budget total manufacturing cost?
Ball Bearings, Inc., faces costs of production as follows: QUANITY TOTAL FIXED COSTS (DOLLARS) TOTAL VARIABLE...
Ball Bearings, Inc., faces costs of production as follows: QUANITY TOTAL FIXED COSTS (DOLLARS) TOTAL VARIABLE COSTS (DOLLARS) 0 180 0 1 180 80 2 180 140 3 180 180 4 180 240 5 180 320 6 180 450 Complete the following table by calculating the company’s total cost, marginal cost, average fixed cost, average variable cost, and average total cost at each level of production. QUANITY TOTAL COST (DOLLARS) MARGINAL COST (DOLLARS) AVERAGE FIXED COST (DOLLARS) AVERAGE VARIABLE COST...
Your company has fixed costs of $150,000 per year. The variable costs per unit in 2018...
Your company has fixed costs of $150,000 per year. The variable costs per unit in 2018 were $3 per unit, and 30,000 units were produced that year. Your company uses cost-based pricing and has a profit margin of $3 per unit. In 2019, production increased and your team had more experience—variable costs went down to $2 per unit because of your team’s higher skill and 65,000 units were produced that year. What is the change in selling price from 2018...
Direct Materials, Direct Labor, and Reports budgeted and actual costs for variable and fixed factory overhead...
Direct Materials, Direct Labor, and Reports budgeted and actual costs for variable and fixed factory overhead along with the related controllable and volume variances.Factory Overhead Cost Variance Analysis Mackinaw Inc. processes a base chemical into plastic. A detailed estimate of what a product should cost.Standard costs and actual costs for direct materials, direct labor, and factory overhead incurred for the manufacture of 7,200 units of product were as follows: Standard Costs Actual Costs Direct materials 9,400 lb. at $5.20 9,300...
ABC Corp. The company has fixed costs of $300,000. Total costs, both fixed and variable, are...
ABC Corp. The company has fixed costs of $300,000. Total costs, both fixed and variable, are $378,000 when 40,000 units are produced. How much is the variable cost per unit? (Please round to the nearest cent.) The following information pertains to the ABC Corporation: Total Units for information given 7000 Fixed Cost per Unit $200 Selling Price per Unit $325 Variable Costs per Unit $225 Target Operating Income $100,000 How many units need to be sold in order to reach...
What is the difference between fixed costs and variable costs?’ Are there fixed costs in the...
What is the difference between fixed costs and variable costs?’ Are there fixed costs in the long run? Explain briefly. Are fixed costs also sunk costs? Explain. What are diminishing marginal returns as they relate to costs? Which costs are measured on a per-unit basis: fixed costs, average cost, the average variable cost, variable costs, and marginal cost? How is each of the following calculated: marginal cost, average total cost, average variable cost? What shapes would you generally expect each...
Variable, Fixed, and Mixed Costs Classify the following costs of activity inputs as variable, fixed, or...
Variable, Fixed, and Mixed Costs Classify the following costs of activity inputs as variable, fixed, or mixed. Identify the activity and the associated activity driver that allow you to define the cost behavior. For example, assume that the resource input is “cloth in a shirt." The activity would be "sewing shirts," the cost behavior "variable," and the activity driver "units produced." Prepare your answers in the following format: Activity Cost Behavior Activity Driver a. Flu vaccine Assembling Delivering orders Filing...
Solitaire Company’s fixed budget performance report for June follows. The $318,750 budgeted expenses include $255,000 variable...
Solitaire Company’s fixed budget performance report for June follows. The $318,750 budgeted expenses include $255,000 variable expenses and $63,750 fixed expenses. Actual expenses include $71,450 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,500 10,900 Sales (in dollars) $ 425,000 $ 545,000 $ 120,000 F Total expenses 318,750 381,500 62,750 U Income from operations $ 106,250 $ 163,500 $ 57,250 F Prepare a flexible budget performance report showing any variances between budgeted and actual results. List fixed and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT