Product Inventory Holding Cost ($/unit-mo) A 1.0 B 3.0 Demand Forecast May June July Product A 300 100 500 Product B 600 200 400 All stockouts are backordered Workforce 15 workers No hiring is possible. Capacity 160 hours per worker per month regular time = 40 hours per worker per month overtime Regular time wage rate = $12 per hour Overtime wage rate = 1.5 X regular time wage rate Suppose our plan is to produce, over the months of May, June and July, 300, 300 and 300 units of Product A and 400, 400, and 400 units of Product B. At the end of June our on-hand inventory of Product B would be..? A. <= 0 B.> 0 and <= 50 C. >50 and <= 100 D. >100 Std. Time (person- hrs/part) 2 4 Beginning Inventory 0 0 Backorder Cost ($/unit-mo) 10 20

Product Inventory Holding Cost ($/unit-mo) A 1.0 B 3.0 Demand Forecast May June July Product A 300 100 500 Product B 600 200 400 All stockouts are backordered Workforce 15 workers No hiring is possible. Capacity 160 hours per worker per month regular time = 40 hours per worker per month overtime Regular time wage rate = $12 per hour Overtime wage rate = 1.5 X regular time wage rate Suppose our plan is to produce, over the months of May, June and July, 300, 300 and 300 units of Product A and 400, 400, and 400 units of Product B. At the end of June our on-hand inventory of Product B would be..? A. <= 0 B.> 0 and <= 50 C. >50 and <= 100 D. >100 Std. Time (person- hrs/part) 2 4 Beginning Inventory 0 0 Backorder Cost ($/unit-mo) 10 20

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

The topic is about Quantitive analysis and decision making. Problem: A firm just completed a new plant that will producemore than 500 different products, using morethan 50 different production lines and machines.The production scheduling decisions are criticalin that sales will be lost if customer demands arenot meet on time. If no individual in the firmhas experience with this production operationand if new production schedule must begenerated each week, why should the firmconsider a quantitative approach to theproduction scheduling problem?
West Company’s contribution format income statement for March 2020 is givenbelow:Sales (15,000 units X $30 per unit) $450,000Variable expenses 315,000Contribution margin 135,000Fixed expenses 90,000Net operating income $ 45,000The industry in which West Company operates is quite sensitive to regularmovements in the economy. Thus, profits vary considerably from year to yearaccording to general economic conditions. The company has a large amount ofunused capacity and is studying ways of improving profits.Required:The company CEO has asked you as a Senior Manager to evaluate the belowsituations with recommendations:1- New equipment has come onto the market that would allow WestCompany to automate a portion of its operations. Variable expenseswould be reduced by $9 per unit. However, fixed expenses wouldincrease to a total of $225,000 each month. How Net Income wouldappear if the new equipment were purchased. As a Senior Manager,what factor/s would be paramount in your mind deciding…
A manufacturing company has the following financial information (in millions of $)Sales $562Cost of goods soldDirect labor 43Purchased materials 267Overhead 35All other costs 142Pretax earnings 75a. What is the profit leverage effect of purchasing in this company?b. What is the percent increase in earnings from a 5 percent savings in purchasing?
1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
Aurillo Equipment Company (AEC) projected that its ROE for next year would be just 6 percent.However, the financial staff has determined that the firm can increase its ROE by refinancing somehigh interest bonds currently outstanding. The firm’s total debt will remain at $200,000 and the debtratio will hold constant at 80 percent, but the interest rate on the refinanced debt will be 10 percent.The rate on the old debt is 14 percent. Refinancing will not affect sales, which are projected to be$300,000. EBIT will be 11 percent of sales and the firm’s tax rate is 40 percent. If AEC refinances itshigh interest bonds, what will be its projected new ROE?
The manager of a live stock feed company faces a production function Q=2L^0.5 K^0.5 where K represents capital equipment and L is labour.Assume the company has spent $16,000 4 units of capital equipment it owns.If workers at the firm are paid a competitive wage of $100 per worker and Feed Can be sold for $200per unit . 1.what is your profit maximising level of output and labour usage 2.what is your maximum profit 3.Use the production function to get the profit function.
Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
Pam's business earns $33,000 per month. Pam's non-employee expenses are $13,500 per month. If Pam wants $4,500 in profit per month, how many employees can she employ if each employee costs $3,000 per month? A. 2.5 employees B. 5 employees C. 6 employees D. 4 employees
Dark beer is purchased by the case for $18.90. There are 24 bottles in each case, and each bottle contains 12 fluid ounces. You are making brine that requires 2 ½ quarts of dark beer. How much will the beer cost for the brine?
1.The company has three months (April. May and June) for subtracting the units for both NOOR-Company's and AL-SALAM company 2. The company should first satisfy AlNOOR company demand then AL-SALAM company demand. 3. Both production units will work in producing the units 4. Production Unit B will be busy during April 5. The company can work up to 24 hours per day 6. The profit should be at least $1500 Do you think that XYZ-Company should accept or reject the offer?
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.