SOLVE THE FOLLOWING USING EXCEL 8. A manager is trying to decide whether to purchase a certain part or to have it produced internally. Internal production could use either of two processes. One would entail a variable cost of $17 per unit and an annual fixed cost of $200,000; the other would entail a variable cost of $14 per unit and an annual fixed cost of $240,000. Three vendors are willing to provide the part. Vendor A has a price of $20 per unit for any volume up to 30,000 units. Vendor B has a price of $22 per unit for demand of 1,000 units or less, and $18 per unit for larger quantities. Vendor C offers a price of $21 per unit for the first 1,000 units, and $19 per unit for additional units. a. If the manager anticipates an annual volume of 10,000 units, which alternative would be best from a cost standpoint? For 20,000 units, which alternative would be best? b. Determine the range for which each alternative is best. Are there any alternatives that are never best? Which?

SOLVE THE FOLLOWING USING EXCEL 8. A manager is trying to decide whether to purchase a certain part or to have it produced internally. Internal production could use either of two processes. One would entail a variable cost of $17 per unit and an annual fixed cost of $200,000; the other would entail a variable cost of $14 per unit and an annual fixed cost of $240,000. Three vendors are willing to provide the part. Vendor A has a price of $20 per unit for any volume up to 30,000 units. Vendor B has a price of $22 per unit for demand of 1,000 units or less, and $18 per unit for larger quantities. Vendor C offers a price of $21 per unit for the first 1,000 units, and $19 per unit for additional units. a. If the manager anticipates an annual volume of 10,000 units, which alternative would be best from a cost standpoint? For 20,000 units, which alternative would be best? b. Determine the range for which each alternative is best. Are there any alternatives that are never best? Which?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

spaces between figures) * Your answer There are 2 policies suggested by Procurement related to inventories. Policy A suggests: Order 150 units. ROP is 50 units and the time between placing and receiving an order is 10days. Policy B suggests: Order 200 units. ROP is 75 units and the time between placing and receiving an order is 15days.Order cost is P20.00 per order and the cost of keeping inventory is P 0.02 per day. Which policy do you think is the best for the company to adopt and what is the cost. Policy A Policy B How much is the cost of production planning A using chase demand? Write your
Breakeven between Two AlternativesGiven:Option A – Buying a MachineFC = 400,000.00 pesosSV = 80,000.00 pesosi = 10.00%n = 8 yearsAnnual Maintenance cost = 5,000.00 pesos/yearProduction cost = 800.00 pesos/dayOutput = 40 units/dayOption B – Manual ManufacturingAnnual cost = 30,000.00 pesos/yearProduction cost = 1200.00 pesos/dayOutput = 30 units/daya. Option A Annual Cost Equation = ?b. Option B Annual Cost Equation = ?c. Units per year for Breakeven = ?
The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…
Borges Machine Shop, Inc., has a 1-year contract for the production of 225,000 gear housings for a new off-road vehicle. Owner Luis Borges hopes the contract will be extended and the volume increased next year. Borges has developed costs for three alternatives. They are general-purpose equipment (GPE), flexible manufacturing system (FMS), and expensive, but efficient, dedicated machine (DM). The cost data follow: Annual contracted units Annual fixed cost Per unit variable cost General-Purpose Equipment (GPE) 225,000 $125,000 $18.00 The option GPE is best when the contracted volume is below Flexible Manufacturing System (FMS) Dedicated Machine (DM) 225,000 $500,000 $13.00 225,000 $200,000 $14.00 ☐ units (enter your response as a whole number).
A book publisher has i xed costs of $300,000 and variable costs per book of $8.00. Thebook sells for $23.00 per copy.a. How many books must be sold to break even?b. If the i xed cost increased, would the new break-even point be higher or lower?c. If the variable cost per unit decreased, would the new break-even point be higher or lower?
Answer 12.7a-c Please show detailed calculations or software output
12 The transparent conceptual framework consists of three component layers: the public strategic component, the customer/user and public demand component, as well as the public value creation component. Select one: a. True b. False
Josh Smith, the materials manager at a retail store, has determined that a particular product experienced 5 turns last year, with an annual sales volume of $15 million. What was the average inventory value for this product last year? $2.5 million $2.75 million $3 million $5 million
Suppose we have a business of supplying fruits and vegetables to customers. So How to manage a order when there is lack of team members(more then 3-5 employes on leave on same time ) in the order management and order need to be fulfilled in short span of time in the following situations :-I) When Delivery team missing II) When Packaging Team missingIII) When Billing Team missing (Answer in points only ) upvote for quality answer
7. The semiconductor used in Costin Calculator has 5 components with the consistency of 90%, 95%,98%, 90%, and 99%, respectively. How reliable is one product of calculator?
Quantity and quality reduction strategy is a decision that applies changes with the current brand to adopt with the current need of the customer in the economy because: a. sales target are no longer achievable b. on-going economic recession c. price are no longer acceptable d. attain sustainable market share
Demand(box) 10 11 12 13 14 15 and and more less Possibility 0.1 0.18 0.26 0.24 0.12 0.1 A business that will open a gift shop in Los Angeles is considering making and selling love- themed magnets. It is thought that it will not be possible to order new magnets during the fair period, and magnets that are not sold during the fair period will not be sold later. A box of magnets costs the business $100 and generates $460 from its sale. The table includes predictions about demand probabilities. a-) What is the overstocking cost of the business in dollars/box? b-) How many dollars/box is the missing stocking cost?