Please calculate the correct values for the regular AND overtime production and also calculate net profit, show answers please I have to finish this tonight, thank you! ing Glassmework iWeek 4: Modeling -202310 BAD305-OS IntrodNew Exercise Bank Content Qu. 07-06Click here for the Excel Data FileDecorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summermonths. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers,Decorum can produce up to an additional 75 units at a cost of $345 each. Decorum sells the ceiling fans for $510 each. Decorum cancarry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the startof January.Complete this question by entering your answers in the tabs below.Required A Required BRegular productionENITOvertime productionM McGraw Hill - ConnectBuild and solve a linear programming spreadsheet model to maximize the profit over all 12 months.a. Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce eachmonth (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their totalprofit?b. Determine the net profit.January FebruaryMarch AprilMayezto.mheducation.comAssuming Decorum must produce enough ceiling fans to meet demand, how many celling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over thecourse of the next year so as to maximize their total profit?Note: Leave no cells blank. Enter zero (0) whenever required.JuneSavedJulyRequired AM Question 3-Week 4 Homework ConnectAugustPrevSeptemberRequired B3 of 10NovemberOctoberNext CDecemberDashboard ing Glassmework iWeek 4: Modeling -202310 BAD305-OS IntrodNew Exercise Bank Content Qu. 07-06Click here for the Excel Data FileDecorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summermonths. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers,Decorum can produce up to an additional 75 units at a cost of $345 each. Decorum sells the ceiling fans for $510 each. Decorum cancarry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the startof January.Complete this question by entering your answers in the tabs below.Required A Required BRegular productionENITOvertime productionM McGraw Hill - ConnectBuild and solve a linear programming spreadsheet model to maximize the profit over all 12 months.a. Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce eachmonth (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their totalprofit?b. Determine the net profit.January FebruaryMarch AprilMayezto.mheducation.comAssuming Decorum must produce enough ceiling fans to meet demand, how many celling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over thecourse of the next year so as to maximize their total profit?Note: Leave no cells blank. Enter zero (0) whenever required.JuneSavedJulyRequired AM Question 3-Week 4 Homework ConnectAugustPrevSeptemberRequired B3 of 10NovemberOctoberNext CDecemberDashboard

Question

Please calculate the correct values for the regular AND overtime production and also calculate net profit, show answers please I have to finish this tonight, thank you! ing Glassmework iWeek 4: Modeling -202310 BAD305-OS IntrodNew Exercise Bank Content Qu. 07-06Click here for the Excel Data FileDecorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summermonths. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers,Decorum can produce up to an additional 75 units at a cost of $345 each. Decorum sells the ceiling fans for $510 each. Decorum cancarry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the startof January.Complete this question by entering your answers in the tabs below.Required A Required BRegular productionENITOvertime productionM McGraw Hill - ConnectBuild and solve a linear programming spreadsheet model to maximize the profit over all 12 months.a. Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce eachmonth (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their totalprofit?b. Determine the net profit.January FebruaryMarch AprilMayezto.mheducation.comAssuming Decorum must produce enough ceiling fans to meet demand, how many celling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over thecourse of the next year so as to maximize their total profit?Note: Leave no cells blank. Enter zero (0) whenever required.JuneSavedJulyRequired AM Question 3-Week 4 Homework ConnectAugustPrevSeptemberRequired B3 of 10>NovemberOctoberNext >CDecemberDashboard ing Glassmework iWeek 4: Modeling -202310 BAD305-OS IntrodNew Exercise Bank Content Qu. 07-06Click here for the Excel Data FileDecorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summermonths. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers,Decorum can produce up to an additional 75 units at a cost of $345 each. Decorum sells the ceiling fans for $510 each. Decorum cancarry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the startof January.Complete this question by entering your answers in the tabs below.Required A Required BRegular productionENITOvertime productionM McGraw Hill - ConnectBuild and solve a linear programming spreadsheet model to maximize the profit over all 12 months.a. Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce eachmonth (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their totalprofit?b. Determine the net profit.January FebruaryMarch AprilMayezto.mheducation.comAssuming Decorum must produce enough ceiling fans to meet demand, how many celling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over thecourse of the next year so as to maximize their total profit?Note: Leave no cells blank. Enter zero (0) whenever required.JuneSavedJulyRequired AM Question 3-Week 4 Homework ConnectAugustPrevSeptemberRequired B3 of 10>NovemberOctoberNext >CDecemberDashboard

Accepted Answer

Aggregate planning is a marketing activity that does an aggregate plan for the production process,…