Create a level plan with a zero ending inventory for the forecast shown in the table. There is no beginning inventory and regular production capacity is 300 units. Overtime costs K15 extra and is limited to 25 units per month and subcontracting is limited to 60 units per month and costs K10 per unit. Back orders cost K50 per unit and there is a cost of KS per month to hold a unit in inventory. What is the total plan cost? |Month January February Forecast 250 300 March 400 April 350
Q: Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming…
A: Given Information: Step 1: Quarter Demand 1 1400 2 1000 3 1500 4…
Q: Problem 4. Considered a (s,S) system, with s = 80 and S = 200. The forecasted demand for the next 12…
A: In s,S system (minimum/maximum inventory system), the operator has to replenish the inventory in…
Q: Month Demand Production End Inventory Stockouts Inventory Cost Stockouts Cost Hiring Cost Firing…
A: Given Information: Inventory holding cost = $ 20 per unit per month Stockout cost of lost sales = $…
Q: Explain why aggregate planning is different when a business does not produce a tangible good
A: Aggregate planning is a technique for forecasting the volume and timing of future demand (3-18…
Q: Prepare a Master Production Schedule (MPS) for an Agri-Chemical company given the following…
A: First calculate the projected-on hand inventory for each period using the following formula.…
Q: A Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current…
A: Find the Given details below: Month January February March April May June July August September…
Q: Prepare a master schedule. The forecast foreach week of an eight-week schedule is 50 units. The MPS…
A:
Q: Aggregate demand for a product family is given in the table below for the 4 quarters of 2021.…
A: Aggregate plan helps the company to procure in an optimal way while saving as much money as…
Q: The opening backlog is 800 units. Forecast demand is as shown here. Calculate theweekly production…
A:
Q: 1. Osprey Machine Works has the following demand requirements and other data for the upcoming four…
A: 1. level plan
Q: Given the projected demands for the next six months, prepare an aggregate plan that uses inventory,…
A: The management of a company uses aggregate planning in order to get an idea about the material…
Q: You are responsible of developing the six-month aggregate production plan at Sodas Galore, a…
A: Find the given details below: Month Jan Feb Mar Apr May Jun Total Sales Forecast (cases) 24000…
Q: 1.- The next table shows the demand forecast for a group of products Month July August September…
A: Note: Since a unit needs 5 hours and 2 will need 10 hours, while the available hours per day are…
Q: The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements…
A: Given- Hiring cost per unit = $50 Layoff cost per unit = $80 Carrying cost per unit = $25 Stockout…
Q: Need help answering the following question in a well written paragraph. Two recommendations (based…
A: A potential market is a segment of the population that has expressed an interest in purchasing a…
Q: Boots Style, Inc. Purchases Budget- Material A For the First Quarter of 2021
A: Given that: Sales Budget(units) Jan 157000 Feb 162000 Mar 204000 Apr 223000 May…
Q: A company wants to develop a level production plan for a family of products. Theopening inventory is…
A: Formula:
Q: Develop a S&OP plan by month for fiscal year 2015. Consider the use of several different…
A: S&OP (Sales and operations planning )is a business management process with the help of which the…
Q: Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning…
A: Given data is Production quantity = 40000 pounds Safety stock = 30000 pounds
Q: What are major limitations of using the tra nspo rtation method for aggregate planning?
A: A small introduction of Aggregate Planning Aggregate planning is a logical apparatus that…
Q: The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements…
A: The process of ordering, storing, using, and selling a company's inventory is called inventory…
Q: Given the projected demands for the next six months, prepare aggregate plan must wind up with no…
A: The projected demands for the next six months - Month 1 2 3 4 5 6 Forecast 150 170 140 160 130…
Q: A company wants to develop a level production plan for a family of products. The opening inventory…
A: Planning is the foundation of any organization's success and growth. Planning dome regarding the…
Q: Given the projected demands for the next six months, prepare an aggregate plan that uses inventory,…
A:
Q: Period Forecast Cust.Ord.…
A: Master plan scheduling is used to determine what quantity of products must be ordered at what time…
Q: Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made…
A:
Q: Which of the following aggregate planning strategies cannot impact the demand 1)subcontracting…
A: A balanced scorecard is a strategic management performance used to improve and identify internal…
Q: NowJuice, Inc. produces bottled pickle juice. A planner has developed an aggregate forecast for…
A: As per our calculation, this answer is not correct. we are solving it the correct way given,
Q: The production manager at Zam Tech has developed following aggregate forecast of its products:…
A: Find the Given details below: Period 1 2 3 4 5 6 7 Total Forecast 50 44 55 60 50 40 51 350
Q: Prepare a Master Schedule like that shown in Figure 11.11 given the following information: The…
A: MPS ordering rule is to be used here. The calculations are shown below: Week Prev week inv Req…
Q: Southeast Soda Pop, Inc., has a new fruit drink forwhich it has high hopes. John Mitten thai, the…
A: A Small Introduction about Inventory A stock is the supply of things utilized in an association. A…
Q: Figure 1 shows the BOMS for two products, A and B. Table 1 shows the MPS quantity start date for…
A: In POQ technique we procure for a given set of duration when there is a procurement order needs to…
Q: Prepare a master schedule given this information: The forecast for each week of an eight-week…
A:
Q: Prepare a Master Production Schedule (MPS) for an Agri-Chemical company in Malawi given the…
A: According to the given data, Inventory = Inventory from previous week - Current weeks requirements…
Q: 2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that…
A: For level production planProduction per Month = (Sum of the total forecast for all period –…
Q: 1.Describe the overall frameworks for resource planning in both goods-producing and…
A: "Since you have asked multiple questions we will solve the first question for you. If you want any…
Q: Aggregate Planning A company has the following aggregate demand requirements and other data for the…
A: In chase aggregate planning, the output production is matched with the demand either by using…
Q: A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an…
A: A level strategy refers to when an aggregate plan is produced such that a steady production rate…
Q: Plan production for a four-month period (February through May
A: It is given in that the cost of hiring a new worker is $50, and layoff is $70 per worker, inventory…
Q: A company is in the process of preparing a budget for launching a new product. The following table…
A: A project network diagram is a graphic depiction of a project's process. A network diagram is a…
Q: Prepare a master schedule based on the following information: Week 1 3 6 78 4 Forecast 500 500 600…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: Prepare a master schedule based on the following information: Week 1…
A: Given Data- Week 1 2 3 4 5 6 7 8 Forecast 500 500 600 600 750 750 900 800 Orders 540 470 325…
Q: I am working on determining optimal order quantity for the Sport Obermeyer case. " Using the data in…
A: To think about the standard deviation of interest, apply the accompanying principle for deciding…
Q: CVP Analysis with Income Taxes Cohen Company produces and sells socks. Variable cost is$6 per pair,…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…
Q: Develop an aggregate plan that matches the forecast and compute the total cost of your plan. Regular…
A: Aggregate planning refers to the “big picture” approach involved in planning, wherein the aggregate…
Q: a) What is the economic quantity for Ben to order? b) At what inventory level should he place an…
A: Annual Demand (D) = 5000Cost = $ 3Ordering cost (O) = $ 10Holding Cost (H) = 20% of Cost = $…
Q: What is the relationship between the aggregate plan andthe master production schedule?
A: Management accounting and control may be defined as a system in which data is collected, processed,…
Q: Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made…
A: Using the given information, the bill of material will be as follows.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 1000 units per month can be used. Backorders are allowed, and they are charged at the rate of $8 per unit per month. Inventory holding costs are $1 per unit per month based on maximum inventory. Determine the cost of this plan if regular time cost is $20 per unit, beginning inventory is zero, and initial backlog from previous plan is 100. Month Forecast 1 800 2 100 3 1200 4 1100 5 1000 6 900 a. Prepare an aggregate plan.b. Prepare an aggregate plan if the management decided to switch to chase…A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 500 units per month can be used. Backorders are allowed, and they are charged at the rate of $20 per unit per month. Inventory holding costs are $1 per unit per month in ending inventory. Determine the cost of this plan if regular time cost is $10 per unit and beginning inventory is zero. Overtime costs $16 per unit and subcontracting costs $20 per unit. In the 4th month, overtime is not possible. While outsourcing is not possible in the 3rd month. Overtime capacity is 50 units and subcontracting capacity is 50 units. Month Forecast 1 400 2 480 3 560 4 720 5…Table below provides the demand forecast and production day information for an aggregate plan. Assume that no back orders are allowed in this case. Month January February March April May June Demand Forecast 3,000 4,500 3,400 2,500 4,000 3,200 Production Days 22 18 21 21 22 20 The costing information that is used to evaluate the total cost of each plan is as follows:• Inventory carrying cost: $4 per unit per month• Subcontracting cost per unit: $15 per unit• Working hours: 8 hours per day• Average pay rate: $12 per hour ($96 per day per worker)• Labour-hours to produce a unit: 2 hours per unit• Cost of increasing daily production rate (hiring and training): $300 per unit• Cost of decreasing daily production rate (layoffs): $700 per unitUse these information to formulate an aggregate plan. The firm would like to use level strategy: constant workforce for the aggregate planning. The firm chooses the average demand of the…
- The forecast demand for fudge for the next four months is 120, 160, 20, and 60 pounds. a. What is the recommended production rate if a level strategy is adopted with no backorders or stock outs? b. What is the ending inventory for Month 4 under this plan? c. What is the level production rate with no ending inventory in month 4.The forecasted demand for fudge for the next four months is 110, 140, 230, and 160 pounds. What is the recommended production rate if a level strategy is adopted with no backorders or stockouts? What is the ending inventory for month 4 under this plan? Round your answers to the nearest whole number. Production rate: pounds/month Ending inventory (month 4): pounds What is the level production rate with no ending inventory in month 4? Round your answer to one decimal place. Production rate: pounds/monthIn aggregate planning, if the beginning inventory for January is 500, the forecasted demand is 1800 and the safety stock is 450, what will be the production requirement in January? A. 1900 B. 1850 C. 1800 D. 1750
- Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 150 units per month. Overtime capacity is 20 units per month. Overtime cost is $30 per unit, backorder cost is $20 per unit. inventory holding cost is $5 per unit, regular time cost of $20 per unit, and beginning inventory is zero. MONTH FORECAST 1 180 2 170 3 140 4 150 5 130 6 150What is the BOM stock needed for the shoe department for April if the sales are planned at $64,000 and the stock to sales ratio is 18.3?The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,100 February 1,700 June 2,100 March 1,600 July 1,700 April 1,900 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $60 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. Evaluate the following plans D and E. Plan D: Keep the current workforce stable at producing 1,600 units per month. In addition to the regular production, another 20% of the normal production units can be produced in overtime at an additional cost of $50 per unit. A warehouse now constrains the maximum allowable inventory on hand to 600 units or less. Note: Do not produce in overtime if production or inventory are adequate to cover demand.…
- Deb Bishop Health and Beauty Products has developed a new shampoo and you need to develop its aggregate schedule. The cost accounting department has supplied you the cost relevant to the aggregate plan and the marketing department has provided a four-quarter forecast. the four-quarter forecast. Quarter Forecast 1 1,400 2 1,100 3 1,700 4 1,300 aggregate plan. Costs Previous quarter's output 1,600 units Beginning inventory 0 units Stockout cost for backorders $55 per unit Inventory holding cost $11 per unit for every unit held at the end of the quarter Hiring workers $50 per unit Layoff workers $75 per unit Unit cost $35 per unit Overtime $20 extra per unit Subcontracting Not available Your job is to develop an aggregate plan for the next four quarters. Part 2 a) Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole…Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders occur. There are 100 workers on January 31. You are given the following demand forecast: February, 90,000; March 65,000; April 110,000; May, 55,000. Productivity is four units per worker hour, eight hours per day, 20 days per month. Assume zero inventory on February 1. Costs are hiring, $50 per new worker; layoff, $70 per worker laid off; inventory holding, $10 per unit-month; straight-time labor, $10 per hour; overtime, $15 per hour; backorder, $20 per unit a. Find the total cost of this plan?The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,500 May 2,300 February 1,700 June 2,100 March 1,700 July 1,900 April 1,700 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement=18001800 units. (Enter your response as a whole number.) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in…