Part 3 Company budgeted for: 108,000 Units USB Inc. predicted 2019 variable and fixed costs are as follows VariableFixed costs costs Manufacturing Selling and Administrative Total 1,728,000 432,000 216,00060.500 1,944,000 492,500 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 Direct labor $5 Variable Manufacturing Overhead Fixed Manufacturing Overhead -allocated per unit Total manufacturing costs $20 The following is the variable selling and administrative costs for the fash drive: $2 Management has set a 2019 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 Use the vanable cost markup you determined in #1 above to determine a suX ested 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 2 2 3 For the flash drive break the markup determined in #2 above on variable costs into separate parts for fixed costs and profit. Markup for fixed costs Markup for profit Total Markup which should agree with what you calculated in #2 above for markup above variable cost Explain and provide what the minimum unit selling price this company would use in special order decision, if the company had excess capacity 4. 3 5. In the long run, what would be the lowest unit selling price this company would sell for? Explain your