Question: Please solve using EXCEL Spreadsheet Showing the formula. Thank you You are the operations manager for an OEM manufacturing plant that produces YBOX game consoles.
Please solve using EXCEL Spreadsheet Showing the formula. Thank you



You are the operations manager for an OEM manufacturing plant that produces YBOX game consoles. Based on the sales record from 2020 , the marketing manager forecasts the demand for January-June of 2021 as the following: Relevant information includes: As the operations manager, you prefer to keep a constant workforce and production level, absorbing variations in demand through inventory excesses and shortages. Demand not met is carried over to the following month. You currently have 21 workers. a. Which aggregate plan will you use to produce the forecasted demand for YBOX game consoles? b. What is the total cost for the chosen plan? Given \begin{tabular}{|l|c|c|c|c|c|c|} \hline Time Period & January & February & March & April & May & June \\ \hline Demand Forecast & & & & & & \\ \hline Number of Working Days per Month & & & & & & \\ \hline \end{tabular} Costs Aggregate Production Planning Requirements ( 30% Safety Stock) You are the operations manager for an OEM manufacturing plant that produces YBOX game consoles. Based on the sales record from 2020 , the marketing manager forecasts the demand for January-June of 2021 as the following: Relevant information includes: As the operations manager, you prefer to keep a constant workforce and production level, absorbing variations in demand through inventory excesses and shortages. Demand not met is carried over to the following month. You currently have 21 workers. a. Which aggregate plan will you use to produce the forecasted demand for YBOX game consoles? b. What is the total cost for the chosen plan? Given \begin{tabular}{|l|c|c|c|c|c|c|} \hline Time Period & January & February & March & April & May & June \\ \hline Demand Forecast & & & & & & \\ \hline Number of Working Days per Month & & & & & & \\ \hline \end{tabular} Costs Aggregate Production Planning Requirements ( 30% Safety Stock)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
