Using these numbers below can I have some help to do the Sensitivity Analysis

Sales Projections in Units

January 22,729

February 50,744

March 45,964

April 53,674

May 44,611

Projected Sales Price/Unit $97.00

Monthly Projected Selling & Administrative Expenses

Variable Cost/Unit $ 3.00

Fixed Costs $5,432

Production:

Desired Ending Inventory 34.9%

Beginning Inventory (new business) 0

Materials

Desired Ending Inventory 36.5%

Number of Materials per Unit 11.00

Projected Cost/Material Unit $20.00

Beginning Inventory (new business) 0

Direct Labor

Time per Unit (in hours) 2.00

Cost per Hour $11.00

Manufacturing Overhead

Variable Cost/Unit $4.00

Fixed Costs $6,828

SENSITIVITY ANALYSIS

Situation #1:

What would the effect be on the Projected Operating Income if you decreased your selling price by 6% to match a price change by one of your competitors?

Original Operating Income New Operating Income Change in Operating Income % Change

January

February

March

Would you recommend this action? Yes No

Reasoning/Rationale: (Non-financial)

Situation #2

What would the effect be on the Projected Operating Income if you decided to improve your product's quality by buying a raw material that cost 12% more than your current material?

Original Operating Income New Operating Income Change in Operating Income % Change

January

February

March

Would you recommend this action? Yes No

Reasoning/Rationale: (Non-financial)

Situation #3

What would the effect be on the Projected Operating Income if you decided to remove executive bonuses and sales commissions decreasing Variable Selling and Administrative costs by 8%.

Original Operating Income New Operating Income Change in Operating Income % Change

January

February

March

Would you recommend this action? Yes No

Reasoning/Rationale: (Non-financial)

The numbers at the top were randomly placed there by excel when I downloaded the document.