Complete the following master schedule record. Click the icon to view the master schedule record. Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 160 Week Forecasted demand Booked orders Projected ending inventory Master production schedule More Info 2 220 250 Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 570 On-hand inventory at end of week 1: 160 Week 2 220 250 3 280 180 570 280 180 Print 4 280 305 680 5 230 320 4 5 280 230 305 320 680 Done 6 280 255 810 6 280 255 810 7 400 140 7 400 140 8 260 295 760 8 260 295 760 125 9 380 340 9 380 340 - X

Complete the following master schedule record. Click the icon to view the master schedule record. Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 160 Week Forecasted demand Booked orders Projected ending inventory Master production schedule More Info 2 220 250 Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 570 On-hand inventory at end of week 1: 160 Week 2 220 250 3 280 180 570 280 180 Print 4 280 305 680 5 230 320 4 5 280 230 305 320 680 Done 6 280 255 810 6 280 255 810 7 400 140 7 400 140 8 260 295 760 8 260 295 760 125 9 380 340 9 380 340 - X

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

Question 2
Question THREE: Suppose you are given a set of data for output at a company which manufactures detergents over a period of time. You have determined a relation between total operating cost and the quantity produced and is given by the linear regression model as follows: TC=20,000+2,500Q, where TC=Total Operating Cost (in $) per annum and Q = Quantity produced per annum Required: i. Determine the total operating cost in the event that quantity of production is at 4,500, 12,500 and 7,000units. ii. What do you think would be your reservations in relaying on the linear regression model for budgetary planning purposes?
Business Studies Question. Q1. “The government has constant interest in the continued performance and survival of business.’ Giving examples, explain the role of the government as a promoter and protector of business interest in Kenya.
What are the impacts on profits of (effective) agreements concerning production levels between oligopolists? Question 24 options: higher prices and less profit monopoly profit zero profit lower prices and more profit
Q-5 A firm was producing three varieties of an electronics component. Two transport modes have been used such as air and water. The demand is stable (No uncertainty). Top Model Average Model Low model Unit Cost (Rs.) 10,000 8,000 6,000 Mean 300 300 300 Demand/week (Units) Inventory Carrying cost/unit/year (Rs) 6,000 5,000 4,000 The lot size is 1200 units and 300 units for water and air respectively. The transportation cost for air and water are Rs. 440 rupees and Rs. 110 respectively. The lead time of delivery for air and water is 1 week and 4 weeks respectively.The firm is using the cycle stock inventory as the half of pipeline inventory. Determine the optimal decision using following data for stable demand.
Q4: M/S XYZ Company Manufactures Sports bikes and supplies them to the local market. A local sub-contracting manufacturer supplies the wheels to the M/S XYZ Company through a purchase contract. The sub-contracting company initially purchases aluminum billets as raw material and manufactures wheels by forming each billet into wheel rims. Both the rims (front and rear) are assembled with spokes, front and rear hubs. Front wheels comprise a front rim, 24 spokes and a front hub. Rear wheels comprise a rear rim, 24 spokes and a rear hub. (i) Draw the Bill of Material (BOM) tree for the front and rear wheels. (ii) Referring to table 4(1) and 4(ii), complete the Material Requirements Planning (MRP) and determine when to Purchase Orders placed for the spokes. Table 4 (i) Week 12 13 14 15 16 17 Demand for the bikes 80 70 90 120 100 85 Demand of Front Rim 50 40 30 125 The demand of Rear Rim 70 60 80 Table 4 (ii) Part/Component Lead Time Stock on Hand Batch Size Safety Stock Bike 1 200 100 Front…
A Firm must know the laws of a country in which it wants to conduct business and it must understand how the laws are reinforced. Is this statement true or false? Question 1 options: a) True b) False
A market is people or organizations with needs or wants and with the ability and the willingness to buy. Question 30 options: True False
Medium-answer Q1. Discuss with example the four main dimensions in Hofstede’s model.
Question 14
Please solve within 30 minutes.
Q5. BMW sell more ‘3 series’ cars than Ford sell of their comparable “Mondeo” in the UK. When comparing models with comparable levels of performance and equipment the BMW is around £10,000 more than the Ford to buy. Conventional economics would indicate that the cheaper alternative should outsell the more expensive one. Compare the two brands (a BMW 3 variant and a similar Ford Mondeo) using any model such as the “brand building blocks” and use this to explain BMW’s success.