(2-b) A firm's demand in the next four quarters is forecast to be 400, 600, 800, and 700 units. Given that beginning inventory is 600, desired ending inventory in quarter 4 is 300, inventory holding cost is $6 per unit per quarter, and production cost is $50 per unit, calculate the cost of a level production plan.

(2-b) A firm's demand in the next four quarters is forecast to be 400, 600, 800, and 700 units. Given that beginning inventory is 600, desired ending inventory in quarter 4 is 300, inventory holding cost is $6 per unit per quarter, and production cost is $50 per unit, calculate the cost of a level production plan.

Name: (2-b) A firm's demand in the next four quarters is forecast to be 400,
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: (2-b) A firm's demand in the next four quarters is forecast to be 400, 600, 800, and 700 units. Given that beginning inventory is 600, desired ending inventory in quarter 4 is 300, inventory holding cost is $6 per unit per quarter, and production cos

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Given the forecast and booked orders shown in the table, and a beginning inventory of 25, what should the master production schedule quantity be for period 4? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Suppose that an organization is engaged in manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (without using Excel)
Backorders: A company is working on its quarterly aggregate production plan. Its quarter forecasts are 6000, 1000, 2500 and 2000, respectively. Suppose that it will use a level plan with backorders (one that produces at the average demand over the four quarters). What is the ending inventory in Quarter 3? (Do not round your intermediate calculations. Round your final answer to the nearest whole number. Only enter the number. Do not enter any units.)
1. With examples and necessary figures, define the Key Inventory Terms ? 2. Suppose, you are newly appointed as a Sales Manager in Unilever Company and after joining your first assignment is to do the sales forecast for the next quarter. Therefore, explain what would be your approach to do a good sales forecast for the next quarter.
an Shields Communications, Inc., a cellular communications provider based in Michigan, charges $86 per month for an all you can talk service plan. The company plans to increase marketing expenditure next year, but wants to determine the current CLV before making this decision. Variable costs before marketing are $28 per account per month and monthly retention expenditures are $12 per account. Ian Shields Communication's annual attrition rate is 17%, with an annual discount rate of 15%.
Given the following forecast and cost information, Regular time cost $ 40.00 per unitdetermine the total cost of a plan that uses regular time Overtime cost $ 60.00 per unitproduction output of 600 units per month, overtime is subcontracting cost $ 80.00 per unitused when needed up to a maximum of 60 units per holding cost $ 10.00 per unit per monthmonth, and subcontracting is used if additional units are needed to meet the forecast.Month Forecast1 5702 6003 6304 6505 6706 690Totals
The Ace Company sells a single product at a budgeted selling price per unit of $20. Budgeted fixedmanufacturing costs for the coming period are $10,000, while budgeted fixed marketing expenses forthe period are $24,000. Budgeted variable costs per unit include $2 of selling expenses (commission)and $4 of manufacturing costs. What is the budgeted operating income if the anticipated sales volumefor the period is (1) 10,000 units, and (2) 15,000 units? (Round answers to the nearest whole number.)
Chase strategy is considered a sales and operations planning strategy such that: Select one: a. involves hiring and laying off staffs to match the demand forecast b. includes overtime, under-time, and vacation planning to match the demand forecast c. Build anticipation inventory to meet the variability in demand. d. deliberates the full range of supply options
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…
A company wants to develop a level production plan for a family of products. Theopening inventory is 500 units, and a decrease to 250 units is expected by the end ofthe plan. The demand for each of the months is given in what follows. How muchshould the company produce each month? What will be the ending inventory in eachmonth? Do you see any problems with the plan?
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
Suppose that an organization is engaged in the manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (With steps)