Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 22 per unit Variable costs 5 per unit Fixed costs 25,000 per month Assume that the projected number of units sold for the month is 7,000. Consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? d. Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?

Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 22 per unit Variable costs 5 per unit Fixed costs 25,000 per month Assume that the projected number of units sold for the month is 7,000. Consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? d. Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

a) b) c) d) e) f) g) h) i) What is the optimal solution (in words? An additional 4 hours of shaper time became available. Evaluate the effect? Explain- Two hours of Grinder time was lost. Evaluate the effect? An additional 20 units of component 3 was requested. Evaluate the effect. The demand for component 2 decreased by 30 units. Evaluate the effect Suppose that the profit contribution of component 1 increases to $9.00. What is the new optimal solution? Suppose that the profit contribution of component 3 decrease by $2.00 . Would the optimal solution change Is the problem degenerate? Explain! Are there alternative optima in this problem? Explain
Williams Inc. produces fluorescent lightbulbs for commercial use. The accounting manager isattempting to estimate the total cost for the next quarter using the high-low method. He has compileddata and found the high and low costs are $10,000 and $6,000, respectively, and the associated costdrivers are 7,000 and 3,000 packs, respectively. What is the value for b (the variable cost per unit)?What is the value for a (the fixed quantity)?
A company is known to have 4 request periods in 1 year. In the first quarter year demand amounted to 750, the 2nd quarter was 900, the third quarter was 1500, and for the fourth quarter it was 900. If the company has an initial inventory of 100, the desired final inventory is 150 units, the cost of normal hours is 100 rupiah/unit, the overtime hour fee is 125 rupiah/unit, the cost of sub-contract hours is 150 rupiah/unit, and lastly the cost of inventory is known to be 20 rupiah per unit per period. Here is the table of normal hours, overtime hours and subcontracts. Period Normal Hours Ovetime Hours Subcontracts 1 700 146 500 2 800 146 500 3 900 146 500 4 500 146 500 Please specify:a. Total cost!b. How much is produced per quarter?c. Analyze Your Answers!
Lisa makes two sorts of jewelry- Type A and Type B. Type A requires 90 minutes of curving and 1hours of assembly time. On the other hand, Type B requires 45 minutes of curving and 2 hours of assembly time. Lisa can sell Type A for $12 and Type B for $55. Given that Lisa has only 1000 hours of curving 500 hours of assembly time. How many of each type of Jewelry Lisa should make to maximize revenue? Keep in mind that Type A jewelry has to be at least twice the number of Type B jewelry. (Possible Answer: $9875). Do it in Exvel with solver (linear programming) (Suggestion: Convert all the hours to minutes so that you do not end up mixing hours and minutes)
Lisa makes two sorts of jewelry- Type A and Type B. Type A requires 90 minutes of curving and 1hours of assembly time. On the other hand, Type B requires 45 minutes of curving and 2 hours of assembly time. Lisa can sell Type A for $12 and Type B for $55. Given that Lisa has only 1000 hours of curving 500 hours of assembly time. How many of each type of Jewelry Lisa should make to maximize revenue? Keep in mind that Type A jewelry has to be at least twice the number of Type B jewelry. (Possible Answer: $9875) (Suggestion: Convert all the hours to minutes so that you do not end up mixing hours and minutes) CAN YOU DO THIS QUESTION IN THIS TEMPLATE ? Data Curving Assembly Price A 1.5 1 $ 12.00 B 0.75 2 $ 55.00 Model Decision Variables A 0 X B 0 Y…
Imagine you produce baseball caps for local colleges. The selling price is $12/hat regardless of the customer. West Chester University and Millersville University both want hats tomorrow. That leaves you with 24 hours of manufacturing time. You cannot fill both orders in 24 hours. Therefore, you need to choose one. Consider this information: Millersville West Chester Selling price per hat 12 12 Variable Cost per hat 5 6 Production minutes per hat 4 3 Using information from this chapter pertaining to maximizing constrained resources, describe which product you would produce and explain your rationale.
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
The Ace Company sells a single product at a budgeted selling price per unit of $20. Budgeted fixedmanufacturing costs for the coming period are $10,000, while budgeted fixed marketing expenses forthe period are $24,000. Budgeted variable costs per unit include $2 of selling expenses (commission)and $4 of manufacturing costs. What is the budgeted operating income if the anticipated sales volumefor the period is (1) 10,000 units, and (2) 15,000 units? (Round answers to the nearest whole number.)
The Woody Company manufactures slippers and sells them at $10 a pair. Variable manufacturing costs are $4.50 a pair, and allocated fixed manufacturing costs are $1.50 a pair. It has enough idle capacity available to accept a one-time-only special order of 20,000 pairs of slippers at $6 a pair. Woody will not incur any marketing costs as a result of the special order. What would the effect on operating income be if the special order could be accepted without affecting normal sales? (a) $0, (b) $30,000 increase, (c) $90,000 increase, (d) $120,000 increase
an Shields Communications, Inc., a cellular communications provider based in Michigan, charges $86 per month for an all you can talk service plan. The company plans to increase marketing expenditure next year, but wants to determine the current CLV before making this decision. Variable costs before marketing are $28 per account per month and monthly retention expenditures are $12 per account. Ian Shields Communication's annual attrition rate is 17%, with an annual discount rate of 15%.
You work for the Brad’s Nailer Company which manufactures three types of nailers: a pneumatic model, the "ProLine", and a cordless model. You have contracted to supply a national retail chain with all three models of nailers. However, Brad’s nailer production capability is limited in three departments: production, testing, and packaging. The goal is to maximize your revenue. Your answer will be the revenue generated (The number of nailers must be a whole number.) Use Scenario 3 Scenario 1 Scenario 2 Scenario 3 Pneum. Sales Price 76 104 148.50 Pneum. Prod Hrs 1.2 0.4 0.25 Pneum. Test Hrs 0.5 0.3 0.4 Pneum. Pkg Hrs 0.2 0.1 0.1 Pneum. Sales 21,000 20,000 18,000 ProLine Sales Price 135 141 190 ProLine Prod Hrs 0.9 0.6 0.5 ProLine Test Hrs 0.8 0.5 0.5 ProLine Pkg Hrs 0.2 0.2 0.3 ProLine Sales 1,500 1,250 5,750 Cordless Sales Price 89 104.50 137 Cordless Prod Hrs 0.45 0.65 0.3 Cordless Test Hrs 0.5 0.4 0.4 Cordless Pkg Hrs 0.3 0.2 0.2 Cordless Sales…
Answer the following questions using the output below please be brief. If there are two possibleanswers one will suffice. Where necessary a range analysis must be shown.(hint;convert to minutes) g) Suppose that the profit contribution of component 3 decrease by $2.00 . Would theoptimal solution change?h) Is the problem degenerate? Explain! i) Are there alternative optima in this problem?