Question: Consider the following sales forecasts for products A and B: Each unit of product A takes approximately 2.5 labor hours, while each unit of product

Consider the following sales forecasts for products A and B:
Sales Forecasts MONTH PRODUCT A PRODUCT B January February March 700 3,500 Each unit of product A takes approximately 2.5 labor hours, while each unit of product B takes only 1.8 hours.
a. What is the combined (aggregate) sales forecast for products A and B? If this were the only information you had, would you expect resource requirements to increase or decrease from January to June?
b. Use the planning value information to calculate total labor hour requirements in each month. Compare your calculations to your answer to part a. Interpret the results.
c. Would top-down planning or bottom-up planning be better suited to S&OP in this situation? Explain.

Sales Forecasts MONTH PRODUCT A PRODUCT B January February March 700 3,500 3,300 3,200 3,000 2,700 1,000 1,200 1,500 1,900 April May June 2,600 2,100

Step by Step Solution

★★★★★

3.46 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

436-B-M-L-S-C-M (2750).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Given the data and information that follow, compute the total direct cost for each project duration. If the indirect costs for each project duration are $90 (15 time units), $70 (14), $50 (13), $40...

Consider the following sales forecasts for products A and B: Sales Forecasts MONTH PRODUCT A PRODUCT B January 3,500 700 February 3,300 1,000 March 3.200 1,200 April 3.000 1,500 May 2,/00 1900 June...

A specialty chemicals facility manufactures two products A and B in barrels. Products A and B utilize thy same raw material; A uses 120 kg/bbl, while B requires 100 kg/bbl. There is an upper limit on...

Would you expect insulin to increase or decrease the activity of the enzyme ATP-citrate lyase?

=+Each unit of product A takes approximately 2.5 labor hours, while each unit of product B takes only 1.8 hours.

5. Consider the following sales forecasts for products A and B: Each unit of product A takes approximately 2.5 labor hours, while each unit of product B takes only 1.8 hours. a. (**) What is the...

Hydroflask water bottles produces three products. large mouth, small mouth and mini mouth water bottles. The company is currently facing a labor shortage; only 3,200 hours are available this month....

I do not understand why this answer is wrong, I reran the numbers about 4 times and used the same steps for June as well. Also, all of my answers up to this point have been correct. Module 9 Homework...

Please answer ASAP and i will give thumbs up Joyner Company has the following historical collection pattern for its credit sales: 60% collected in month of sale 20% collected in the first month after...

Northcutt's production data for a new deluxe product were taken from the most recent quarterly production budget: July August September Planned production in units 750 850 730 In addition, Northcutt...

Question 2 Snow White Sdn Bhd (SWSB) manufactures and sells product XYZ. Budgeted units to be sold for each quarter of the year 2018 are as follows: Q1 8,000 Q2 10,000 Q3 12,000 Q4 12,500 The selling...

Consider the following chain mechanism: Use the steady-state approximation to deduce that the rate law for the consumption of A2. (1) A,A+A- (2) A B. + C (3) A- +P B- (4) A-+ B-- P

\ \\ Consider the following current ratios for the past five years: 2014 Ind. Average 2.5 2016 2018 3.2 2017 2.9 2015 2.6 Current Ratio 2.8 1.5 Note: Keep your answers brief and to the point-bullet...

Evaluate the integral. ( R e m e m b e r the constant o f integration. ) 2 6 d x 2 6 + e x

Why didnt we use the integral approximation (A.12) directly on P n k = 1 1/k to obtain an upper bound on the nth harmonic number?

The Canada Mortgage and Housing Corporation (CMHC) recommends that monthly housing costs, including monthly mortgage payments, property taxes, and heating expenses, should not exceed 32% of a...

Lander Company manufactures a popular line of work clothes. Lander employs 125 workers and keeps time sheets that show how many hours the employees work each week. On Friday the shop foreman collects...

Even the nearest stars are so distant that a single diffraction limited telescope capable of imaging Earth-size planets orbiting them would be hopelessly large (see Problem 45). Astronomers get...

Many particles are far too short-lived for their lifetimes to be measured directly. Instead, tables of particle properties often list width, measured in energy units and indicating the width of the...

What role do value judgements have in determining what particular accounting theory a researcher might elect to adopt to explain or predict particular accounting phenomena? LO1.4

The Port of Charleston is considering an expansion of their container terminal. The port has experienced the following container throughput during the past 12 years, expressed as TEUs (i.e., 20 feet...

The County Arsenal Travel Soccer Club has boys and girls travel soccer teams at all age levels up to 18 years old. The club has been successful and grown in popularity over the years; however, an...

The Dean of the College of Business at State University has initiated a fund raising campaign. One of the selling points she plans to use with potential donors is that increasing the colleges private...

CompU is looking at starting a major advertising campaign to further expand their business. Based on preliminary estimates, the advertising campaign will cost $100,000 and will increase revenue by...

stats and prb The graph of an exponential function is shown in the figure below. The horizontal asymptote is shown as a dashed line. Find the range and the domain. ...5 ..... ..5.. ..... ...5... . ....

Consider a risky portfolio. The end-of-year cash flow derived from the portfolio will be either $70,000 or $180,000, with equal probabilities of 0.5. The alternative riskless investment in T-bills...