Please help me with this lab project. It's in excel and with formula. I appreciate your help. The... (1 bookmark) Please help me with this lab project. It's in excel and with formula. I appreciate your help.

The questions are on pages 2,3,4.

Joy Appliance Corporation manufactures electric knives and electric can openers. Mr. Joy is in the process of making up his 2017 budget & operating plan. Before drawing his plan, Mr. Joy likes to understand the effects of the pricing and advertising expenditure strategies on the profit after taxes. At first, Mr. Joy analyzed the structure of 2016 costs as follows Analysis of Costs Product Line Electric Knives Electric Openers Selling Price Variable Costs Manufacturing: (per unit cost) $3.75 $3.40 $3.65 First 0.50M units (Knives) Next 0.40M units (Knives) After 0.90M units (Knives) First 0.40M units (Openers) Next 0.45M units (Openers) Next 0.35M units (Openers) After 1.20M units (Openers) S6.65 $6.25 $6.85 $7.00 Marketing Knives Less than or equal to 0.5M units Between 0.5M and 0.8M units Greater than or equal to 0.8M units $1.60 $1.75 $1.80 Openers $1.20 $1.50 First 0.7M units After 0.7M units Fixed Costs (in Thousands) First 0.65M units (Knives) Next 0.45M units (Knives) After 1.1M units (Knives) First 0.55M units (Openers) S550 S500 $600 $650 Show transcribed image text CIS 3700 Information Technology for Management LAB Project #5 SPRING 2017 Joy Appliance Corporation manufactures electric knives and electric can openers. Mr. Joy is in the process of making up his 2017 budget & operating plan. Before drawing his plan, Mr. Joy likes to understand the effects of the pricing and advertising expenditure strategies on the profit after taxes. At first, Mr. Joy analyzed the structure of 2016 costs as follows Analysis of Costs Product Line Electric Knives Electric Openers Selling Price Variable Costs Manufacturing: (per unit cost) $3.75 $3.40 $3.65 First 0.50M units (Knives) Next 0.40M units (Knives) After 0.90M units (Knives) First 0.40M units (Openers) Next 0.45M units (Openers) Next 0.35M units (Openers) After 1.20M units (Openers) S6.65 $6.25 $6.85 $7.00 Marketing Knives Less than or equal to 0.5M units Between 0.5M and 0.8M units Greater than or equal to 0.8M units $1.60 $1.75 $1.80 Openers $1.20 $1.50 First 0.7M units After 0.7M units Fixed Costs (in Thousands) First 0.65M units (Knives) Next 0.45M units (Knives) After 1.1M units (Knives) First 0.55M units (Openers) S550 S500 $600 $650

CIS 3700 Information Technology for Management LAB Project #5 SPRING 2017 Joy Appliance Corporation manufactures electric knives and electric can openers. Mr. Joy is in the process of making up his 2017 budget & operating plan. Before drawing his plan, Mr. Joy likes to understand the effects of the pricing and advertising expenditure strategies on the profit after taxes. At first, Mr. Joy analyzed the structure of 2016 costs as follows Analysis of Costs Product Line Electric Knives Electric Openers Selling Price Variable Costs Manufacturing: (per unit cost) $3.75 $3.40 $3.65 First 0.50M units (Knives) Next 0.40M units (Knives) After 0.90M units (Knives) First 0.40M units (Openers) Next 0.45M units (Openers) Next 0.35M units (Openers) After 1.20M units (Openers) S6.65 $6.25 $6.85 $7.00 Marketing Knives Less than or equal to 0.5M units Between 0.5M and 0.8M units Greater than or equal to 0.8M units $1.60 $1.75 $1.80 Openers $1.20 $1.50 First 0.7M units After 0.7M units Fixed Costs (in Thousands) First 0.65M units (Knives) Next 0.45M units (Knives) After 1.1M units (Knives) First 0.55M units (Openers) S550 S500 $600 $650 CIS 3700 Information Technology for Management LAB Project #5 SPRING 2017 Joy Appliance Corporation manufactures electric knives and electric can openers. Mr. Joy is in the process of making up his 2017 budget & operating plan. Before drawing his plan, Mr. Joy likes to understand the effects of the pricing and advertising expenditure strategies on the profit after taxes. At first, Mr. Joy analyzed the structure of 2016 costs as follows Analysis of Costs Product Line Electric Knives Electric Openers Selling Price Variable Costs Manufacturing: (per unit cost) $3.75 $3.40 $3.65 First 0.50M units (Knives) Next 0.40M units (Knives) After 0.90M units (Knives) First 0.40M units (Openers) Next 0.45M units (Openers) Next 0.35M units (Openers) After 1.20M units (Openers) S6.65 $6.25 $6.85 $7.00 Marketing Knives Less than or equal to 0.5M units Between 0.5M and 0.8M units Greater than or equal to 0.8M units $1.60 $1.75 $1.80 Openers $1.20 $1.50 First 0.7M units After 0.7M units Fixed Costs (in Thousands) First 0.65M units (Knives) Next 0.45M units (Knives) After 1.1M units (Knives) First 0.55M units (Openers) S550 S500 $600 $650