2.17 For the following data, calculate the number of workers required for level productionand the resulting month-end inventories. Each worker can produce 14 units per day, andthe desired ending inventory is 9000 units.MonthWorking DaysForecast DemandPlanned ProductionPlanned Inventory11,5001234Total2024121928,00027,500 28,50028,500

Firstly calculate Total Forecasted Demand:Remember that,Total Production = Total Forecasted Demand −…

Answered: 2.17 For the following data, calculate…

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

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.
The Unique Toys Company manufactures and sells toys. Currently, 300,000 units are sold per year at $12.50 per unit. Fixed costs are $880,000 per year. Variable costs are $7.00 per unit. Consider each case separately: Required: 1. A 10% increase in variable cost. 2. A 10% decrease in fixed costs, a 10% decrease in selling price, a 10% increase in variable cost per unit, and a 25% increase in units sold.
Please do not give solution in image format thanku In 2018, the government of Ghana launched operation one district one factory (IDIE). Based on IDIF, Ekumfi Pineapple Factory Co. Ltd (EPF) was launched. In 2019 the management of ERF started production with 100 workers per shift, each of the three shifts working 8 hours per day. Every working day the payroll cost was GHIC 20,000 and overhead expenses amounted to GHC 5000 and material cost GHC 4000. At the end of the first year, the company produced 1,000,000 boxes of pineapple juice. During the second year, EPF acquired a loan from Exim Bank to purchase a new plant. After the introduction of the new plant, the management reduced the size of its workers per shift to 80, each working 8 hours per day, with the payroll cost reducing to GHC 18,000 and overhead expenses also reducing to GHC 4000 and material cost rising to GHC 6000. Production rose to 1,200,000 boxes. Regard yourself as the Operations Manager of EPF: a) What are the…
College Creations, Inc (CC), builds a loft that is easily adaptable to most dorm rooms or apartments and can be assembled into a variety of configurations. Each loft is sold for $500, and the cost to produce one loft is $300, including all parts and labor. CC has fixed costs of $100,000. A.What happens if CC produces nothing? B.Now, assume CC produces and sells one unit (loft). What are their financial results? C.Now, what do you think would happen if they produced and sold 501 units? D.How many units would CC need to sell in order to break even? E.How many units would CC need to sell if they wanted to have a pretax profit of $50,000?
Arizona Instruments produces bar code scannersfor consumers and other manufacturers on aproduce to stock basis. The production planneris developing an MPS for scanners for the next12 weeks.The product is built in a fixedorder quantityof 125 units, and there are 110 units in beginninginventory. The demand forecasts for the next 12weeks, including customer orders promised tocustomers for delivery in that time period, isshown on the shown on the next slide. Customer Orders Forecast Demand Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 50 50 50 50 75 75 75 75 50 50 50 50 Customer order 35 25 25 20 0 15 0 0 10 0 0 10 Determine the MPS and Available to Promise (ATP)
Adidas is an athletic company designs and manufacturesseveral athletic things. Football is one of the company'sproducts that sells for $40 per unit. Total fixed costs relatedto the manufacturing of the football are $150,000 per monthand variables costs involved in manufacturing are $ 15 per unit. 1-Compute the number of footballs to be sold to earn atarget profit of $30.000.?
A. restaurant is opening in Laie and is going to cater to the rich and the famous. It is a 35 seat A B C D Cash Cost 3000 3200 2700 2000 Estimate life 6 6 6 6 Trade in 500 500 600 0 Installation 675 675 675 675 Initial training 325 350 225 275 Annual training 150 125 125 100 Annual labor 3500…
The CEO of J&B, Ld., would like to propose in the next Council meeting a rise of capital as one of thepossible ways to increase the forecast of the working capital for the next financial year and reached6,000,000 €. This number will allow the company to have a degree of robustness comparable toother competitive companies in the industry. Daily Amount Average Deferments (days)Raw Materials 60.000 10Salaries 150.000 7Overheads 90.000 ? If the operating cycle is 30 days, what should the manager answer if a director asks him about theaverage deferment of the overheads?( answer: Average deferment in Overhead is 15 days) HOW DO I DO THIS?????
Ajax Manufacturing produces a single product, which takes 8.0 pounds of direct materials per unitproduced. Assume that it is currently at the end of the first quarter of the year, and there are 50,000pounds of material on hand. The company’s policy is to maintain an end-of-quarter inventoryof materials equal to 25 percent of the following quarter’s material requirements for production.How many units of product were produced in the first quarter of the year? Under the assumptionthat production will increase by 10 percent in the second quarter, what are the direct materialsrequirements (in pounds) for planned production in the second quarter?
Macon Controls produces three different types of controlunits used to protect industrial equipment from overheating Each of these units must be processed by a machine thatMacon considers to be their process bottleneck. The plantoperates on two 8-hour shifts, 5 days per week, 52 weeks peryear. Table 4.2 provides the time standards at the bottleneck,lot sizes, and demand forecasts for the three units. Becauseof demand uncertainties, the operations manager obtainedthree demand forecasts (pessimistic, expected, and optimis-tic). The manager believes that a 20 percent capacity cushionis best.a. How many machines are required to meet minimum(pessimistic) demand, expected demand, and maximum(optimistic) demand?b. How many machines are required if the operations man-ager decides to double lot sizes? c. If the operations manager has three machines and be-lieves that the plant can reduce setup time by 20 percentthrough process improvement initiatives, does that planthave adequate capacity to…
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing facility. The faucets are made from brass. Manufacturing has 50 employees. Each employee presently provides 32 hours of labor per week. Information about a production week is as follows: Standard wage per hour $12.00 Standard labor time per unit 15 min. Standard number of lbs. of brass 1.5 lbs. Standard price per lb. of brass $11.00 Actual price per lb. of brass $11.25 Actual lbs. of brass used during the week 11,124 lbs. Number of units produced during the week 7,200 Actual wage per hour $12.36 Actual hours for the week (50 employees × 32 hours) 1,600 Required: a. Determine the standard cost per unit for direct materials and direct labor. Round the cost per unit to two decimal places. Direct materials standard cost per unit $fill in the blank 1 Direct labor standard cost per unit $fill in the blank 2 Total standard cost per unit $fill in…
the following are come accounts pertaining to the rooms division od XYZ Inn. salaries and wages $10,000 operating supplies $5,000 sales $200,000 laundry $9,000 commissions $2,000 dry cleaning $500 uniforms $200 fringe benefits and payroll taxes 10% of salaries and wages other expenses 3% of sales 1. using the information provided above, what would the total salaries, wages, service charges, contracted labor and bonuses be equal to on the rooms department schedule for XYZ Inn? 2. using the information provided above, what would the total payroll-related expenses be equal to on the rooms department schedule for XYZ Inn? 3. Using the information provided above, what would the total rooms revenue be equal to on the rooms department schedule for XYZ Inn? 4. Using the information provided above, what would the total expenses be equal to on the rooms department schedule for XYZ Inn? 5. Using the information provided above, what would the total labor costs and related expenses be equal…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS