2. Rollers Inc. uses a contimous budget The mouth of March is about to end, so the company is now preparing estimates for April. Figures for the period January to March pertaining to factory supplies are as follows: Factory Supplies P144,612 Production January February March 90,000 108,000 PI70,712 96,000 P153,312 If the budgeted produetion for April is 94,000 units, how much should be the budgeted factory supplies be?
Q: The following cost information pertains to the new CD: CD package and disc (direct material and…
A:
Q: Level Capacity Production Plan Problem o Manager T. C. Downs of Plum Engines, a producer of lawn…
A: Find the given Details below: Month 1 2 3 4 5 6 7 8 Total Forecast 120 135 140 120 125 125 140…
Q: Q3. Complete the following iteration tableau of Maximization problem of LPP and comment on the…
A: Given information, Cbi Basic variable 2 1 0 0 0 Solution X1 X2 S1 S2 S3 2 X1 1 0 -1…
Q: The main input for master scheduling schedule is: O a. Long term forecasting O b. Aggregate…
A: Ans) 1) Master Scheduling Schedule takes sales forecast as a Input. MPS is an Input to Aggregate…
Q: A manager is going to purchase new processing equipment and must decide on the number ofspare parts…
A: Given Information: Unit spare part cost = $ 200 Salvage Value of a spare part = $ 50 Cost for idle…
Q: 6. The Tech football coaching staff has six basic offensive plays it runs every game. Tech has an…
A: Since you have submitted multiple questions multiple subparts, as per guideline we have answered the…
Q: Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an…
A: A chase plan refers to a plan in which the production level is matched the market demand of the…
Q: In doing "aggregate planning" for a firm producing paint, the aggregate planners would most likely…
A: FIRM- "producing paint" Objective - aggregate planning for producing paint.
Q: Figure 1 shows the BOM for product A. Table 1 shows the MPS quantity start dates for product A, and…
A: Note: For a given week Scheduled receipt and Beginning inventory are treated differently. But once…
Q: Develop a production schedule to produce the exact production requirements by varying the workforce…
A: Aggregate production plan using chase strategy by varying workforce to match production exactly with…
Q: An aggregate planning model is being considered for the following applications.Suggest an aggregate…
A: The aggregate measure of production and difficulty of applying aggregate planning are:a) Planning…
Q: The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing…
A:
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: 1- Dwayne Cole, owner of a Florida firm that manufactures display cabinets, develops an 8- month…
A: a) Formulate a spreadsheet as shown below to find the optimal cost, plan cost = $2608300
Q: Right now is Oct 27, 2021. You are developing an aggregate production pla For 2022. Suppose the…
A: The pursuit methodology alludes to the thought that you are pursuing the demand set by the market.…
Q: A large St. Louis feed mill, Robert Orwig Processing,prepares its 6-month aggregate plan by…
A: A production plan is a budget that is created by a manufacturing firm to account for the…
Q: Sorin Incorporated, a company that produces and sells a single product, has provided its…
A: Contribution margin is the amount obtained by deducting the variable expenses attributable to a…
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: A manager is attempting to put together an aggregate production plan for the coming nine months. She…
A: an aggregate plan using the information given- With 20 permanent workers initially with each…
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: Aggregate planning deals with a number of constraints.These typically are:a) job assignments, job…
A: The process of creating, evaluating, and maintaining a tentative, estimated schedule of an…
Q: The planner at a company that makes garden tractors is about to prepare an aggregate production plan…
A: Disclaimer-Since you have asked multiple question we will solve the first question for you. If you…
Q: Aggregate Planning and Master Scheduling Planners of the company are about to prepare the aggregate…
A: Find the Aggregate plan below: The required total cost is 51100000 LE.
Q: Prepare a master schedule given this information: The forecast for each week of an eight-week…
A:
Q: Jesaki Publishing is planning for a new novel, and figures fixed costs (overhead, advances,…
A: We will first understand each term in the cost function. C(x) is the total cost for a particular…
Q: Shoney Video Concepts produces a line of video streaming servers that are linked to personal…
A: given, Manufacturing cost is $200 per set Inventory storage cost is $5 per month estimated to cost…
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: A manager is attempting to put together an agregate plan for the coming nine months. She has…
A: In a company, the procurement of inventory, its storage as well as management involves huge amounts…
Q: Based on the following sensitivity report, how much should the firm be willing to pay for 76 more…
A: Below is the solution:-
Q: A factory manufactures two products A and B on three machines X, Y, and Z. Product A requires 10 min…
A: Assume X1 = A and X2 = B Given that, The profit contribution of products A and B are 23.00 per unit…
Q: o Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, mUst develop an…
A: Aggregate planning is essentially a "higher perspective" way to deal with planning, where the…
Q: Aggregate planning deals with a number of constraints.These typically are:a) job assignments, job…
A: Aggregate planning is the planning of production activities for an organization that takes into…
Q: The Baldwin Company, in its master budget for 2019, predicted total sales of $160,000, variablecosts…
A: Formula for Total static budget (operating-income) variance, simply subtract the actual spend from…
Q: d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales…
A: The estimated level of inventory that a manufacturer has in stock which can be readily sold is…
Q: 3) Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table…
A: Decision Variables: Let Ri, Oi, Si be the regular, overtime, and subcontracting quantity respective…
Q: Spring and Summer Fashions, a clothing producer, has generated a forecast for the next eight…
A: The steady production of 1,200 units is maintained. As the production rate per worker is not given,…
Q: An aggregate plan is to be developed for the forecast of demand covering nine periods shown in Table…
A: Aggregate planning is a process for creating a long-term manufacturing strategy that assures a…
Q: What are the most common decision variables for aggregate planning in a manufacturing setting?In a…
A: Aggregate planning comprises specification of production requirements our medium period based on…
Q: Edwards and Bell market a single line of home computers, dubbed the XL-98. The master budget forthe…
A: Hence, the total static budget variance in operating profit is $20,000.
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: The company has pre-order for 6 heavy and 4 light balls that must be completed. (i) Calculate the…
A: The answer is as below:
Q: 9/Samsung Company is producing Laptops and Tablets. They are deciding whether to use job-order…
A: Answer : Correct option is (b) OMR 40 per hour
Q: Strong Construction Company is interested in taking loans from banks for some of its projects P, Q,…
A: THE ANSWER IS AS BELOW:
Q: A phone production company must prepare the production planning for the next 9 weeks. Complete the…
A: Gross requirements: It is the total requirement of a particular product. Receipt: It is the placed…
Q: Assuming the role of a consultant Using North West Corner , Least Cost method and Vogels…
A: ANSWER : Project S,T,P taking from co-operative banks S-125 T-75 p- 50 Project P,Q,R taking from…
Q: The Aggies will host Tech in this year's homecoming football game. Based on advance ticket sales,…
A: Cost price = $1.60 Selling price = $2.80 Salvage value = $0.60 Profit = 2.80-1.60 = $1.2 Profit in…
Q: • Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an…
A: Forecasting is the activity of making estimated valuations of future activities based on past and…
Q: C. For what range of P (1) would alternative A be the best choice if the goal is to maximize…
A: Given - Payoff table: Alternative STATE OF NATURE #1 #2 A 40 165 B 141 108 C 115 61
Q: Based on the following sensitivity report, how much should the firm be willing to pay for 53 more…
A: Given sensitivity report-
Please answer it in Good form with explanations. thank you
Step by step
Solved in 2 steps
- Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.March demand was pridicted at 590 units of gear cycles of trevaa Itd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same.
- Q2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole number
- 3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3Table 5.1: The demand forecast developed for the year ended 31 December 2022. Month Production days Demand forecast Jan 16 150 Feb 16 150 Mar 23 250 Apr 21 250 May 22 400 Jun 22 500 Jul 21 600 Aug 20 750 Sep 20 450 Oct 20 250 Nov 16 150 Dec 16 150 1. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). 2. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number).7-3. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next eight months. month Apr forecast 4500 May 4400 Jun 6200 Jul 6400 Aug 5800 Sep 6600 Oct 7200 Nov 6900 Use the following information to develop aggregate plans. Regular production cost: $10.00 per case Regular production capacity: 5,000 cases Overtime production cost: $16 per case Subcontracting cost: $20 per case Holding cost: $1 per case per month Beginning inventory: 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? (a) Use level production of 5,000 case per month. Supplement using overtime as needed (b) Use a combination of overtime (500 cases per month for the first five months), inventory, and subcontracting (500 cases per month from September to November, if necessary) to handle variations in demand. Note that suitable amounts of overtime for the last…
- On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20Mr. Zulhakim being assigned by his manager to develop their production planning for Year 2022. Table 3 shows the information that he able to obtain from the sales & marketing department. After doing the planning, Mr Zulhakim need to present it to his manager. Factory developed a demand forecast based on Table 3 with supplier charges about RM300.00 per unit. The demand forecast is stated as week but, in this planning, it is being considered as an annual quantity for the operation. Ordering cost is RM150.00. Annual holding cost is 10 percent of a purchased price. (b) Develop the ATP of this plan. Initial inventory on hand is 50 units obtained from Year 2021. Lot size for MPS can be obtained by using EOQ model. Table 3: Demand and Customer confirmed order quantity 8 9 10 2 3 10 40 10 00 30 20 40 20 30 Period (Week) 1 4 5 6 7 Forecast (units) Customer orders (booked) (unit) 20 8. 2Solve the following questions Q1. A. From the following forecast determine the monthly inventory balances required to follow a plan of letting the inventory absorb all fluctuations in demand. In this case, we have a constant work force, no idle time or overtime, no back orders, no use of subcontractors, and no capacity adjustment. Assume that the firm does not use safety stock or cushion inventory to meet the demand. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month Forecasted demand 90 220 210 400 612 700 378 220 200 110 100 260 Production days 22 18 21 20 22 20 21 22 20 25 19 20