Transportation Problem (Solve using excel): Acme Block Company has orders for 80 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood -- 10 tons. Acme has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown in the attached image. How should end of week shipments be made to fill the above orders?

Transportation Problem (Solve using excel): Acme Block Company has orders for 80 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood -- 10 tons. Acme has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown in the attached image. How should end of week shipments be made to fill the above orders?

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

Transcribed Image Text On hand: 35 Planning time fence: 10 Lot size: 200 Demand time fence: 2 Period 2 4 6. 7 9. 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer Orders 31 35 29 21 17 14 33 11 5 2 Projected Available Available to Promise MPS 200 200 3. a. Given the following master schedule, fill in the projected available and availableto promise rows: b. A customer wants an order of 100 in period 4. What can you tell him?c. The customer from part (b) cancels his request, but then says he wants 120 in period 5.What do you tell him now?d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction? I only need question D and E answered
Using the information in Problem (The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct a netmaterial requirements plan using the following on-hand inventory.
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 = ?
Explain what factors can create safety stock requirment in an MRP system?
The Best Wheels Bicycle Company produces bicycles indifferent styles for boys and girls, in heights of 26 inchesor 20 inches, and with 10 speeds, 3 speeds, or 1 speed.a. How many different kinds of bicycles does BestWheels make?b. Construct a modular bill of material for Best Wheels(one level). Assume that bike sales are equally splitbetween boys and girls, 26-inch bikes are preferredtwo-to-one to 20-inch bikes, and 3-speed bikes accountfor only 20% of sales. The remaining sales are dividedequally between 10-speed and 1-speed bikes.c. If bicycle sales are expected to reach 10,000 over theholiday shopping season, how many 26-inch bikesshould Best Wheels plan to produce? How many 10-speed bikes?
Percentage Service Provided toDepartment Cost S1 S2 P1 P2Service 1 (S1) $ 112,000 0% 40% 40% 20%Service 2 (S2) 44,000 20 0 40 40Production 1 (P1) 345,000Production 2 (P2) 216,000Total $ 717,000Brief Exercises 7-15 and 7-16 require the following information:7-15 What percentage of S1’s costs is allocated to P1 and to P2 under the direct method?7-16 What percentage of S2’s costs is allocated to P1 and to P2 under the direct method?
How did you get the total demand as 640 and why is the anwser 46 can you express it algebraicly
Assume that you are the manager of a shop that assembles power tools. You have just received an order for 52 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 Develop the material requirements plan for component E using lot-for-lot ordering.
Assume that you are the manager of a shop that assembles power tools. You have just received an order for 52 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank - be certain to enter "0" wherever required.) Item: E(3) & E(2) LT = 1 wk. Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release
Star Symphony would like to perform for a neighbouring city. Fixed costs for theperformance total $5,000. Tickets will sell for $15 per person, and an outside organizationresponsible for processing ticket orders charges the symphony a fee of $2 per ticket. StarSymphony expects to sell 500 tickets.1. How many tickets must Star Symphony sell to break even?2. How many tickets must the symphony sell to earn a profit of $7,000?3. How much must Star Symphony have in sales dollars to break even?4. How much must Star Symphony have in sales dollars to earn a profit of $7,000?5. What is the symphony’s margin of safety in units and in sales dollars?
What will ERP fix in my business?
Subpart 4. Assuming that Brenda can retain Susan as a customer, how can she add value to her relationship with Susan's firm?