The table below provides the aggregate plan of shoes manufactured by BestShoe that uses a chase plan. The firm's labor cost is $10/unit, hiring cost is $200 per unit of increase, and unit firing cost is $250 per unit of decrease in production. Given this information, what is the number in the cell with the question mark? (If needed, round your final answer to nearest whole number. (c)orsdemir. Copyrighted material.) Month# Forecast# Net requirement# Prod. rate# Labor cost# Hiring cost Firing cost 1,000 3,950 3,400 940 3,000 2,500 Jan Feb Mar Apr May 4,100 3,400 940 3,000 2,500 3,950 3,400 940 3,000 2,500 39,500 34,000 9,400 30,000 25,000 590,000 0 0 412,000 0 0 137,500 ? 0 125,000

The table below provides the aggregate plan of shoes manufactured by BestShoe that uses a chase plan. The firm's labor cost is $10/unit, hiring cost is $200 per unit of increase, and unit firing cost is $250 per unit of decrease in production. Given this information, what is the number in the cell with the question mark? (If needed, round your final answer to nearest whole number. (c)orsdemir. Copyrighted material.) Month# Forecast# Net requirement# Prod. rate# Labor cost# Hiring cost Firing cost 1,000 3,950 3,400 940 3,000 2,500 Jan Feb Mar Apr May 4,100 3,400 940 3,000 2,500 3,950 3,400 940 3,000 2,500 39,500 34,000 9,400 30,000 25,000 590,000 0 0 412,000 0 0 137,500 ? 0 125,000

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

Please do not give solution in image format thanku XYZ Mobile makes phones in multiple production lines. The daily production run is for 820 phones. Each phone has a standard time of 5.1 minutes. Each production line operates for 9 hours per day. Do not include commas in your answer and enter percentages as decilmal points. For example enter 1,402 as 1402 and 67.5% as 0.675. How many production lines are needed to meet the daily demand? What is the utilization of the production lines? What is the maximum daily output of the system?
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…
Well water inc. wants to produce and sell a new flavored water in order topenetrate the market, the product will have to sell at 2.60 per 12 oz bottle thefollowing data has been collected: Annual sales 50,000 bottlesProjected selling and administrative costs 8,000Desired profit 80,000The target cost per bottle is _____ per bottle (2 decimal places)
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.
Please answer in excel format A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.
Which of the following terms describes: "the flow of goods, services, and information from the initial sources of materials and services to the delivery of products to consumers"? a. enterprise resource planning (ERP). b. customer list. c. supply chain. d. material requirements planning (MRP).
Help me
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.?
Answer the following questions using the output below please be brief. If there are two possibleanswers one will suffice. Where necessary a range analysis must be shown.(hint;convert to minutes) g) Suppose that the profit contribution of component 3 decrease by $2.00 . Would theoptimal solution change?h) Is the problem degenerate? Explain! i) Are there alternative optima in this problem?
Determine which factor of production is needed in the following problem. 1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine? 2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand? 3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas? 4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?
Briefly describe how STR obtains raw property data. Identify the various metrics used by the hotel Industry, both the raw values, the KPIs, and the Percent Changes. Explain how metrics are calculated when it comes to multiple time periods. Compare the differences between how monthly and daily data is treated Identify “hints” that should be remember when working with the various metrics. Upload your responses
Which of the following changes in cost-volume-profit factors will reduce the break-even point? Group of answer choices a. A decrease in total fixed cost d. An increase in total fixed cost b. A decrease in selling price c. An increase in unit variable cost In a contribution income statement Group of answer choices a. Costs are classified as to function b. Fixed and variable manufacturing costs are combined as one level item d. Fixed manufacturing costs are shown separately from variable manufacturing costs, but fixed and variable operating costs are combined as one line item c. Fixed costs are shown separately from variable cost