hi, I need help with these questions and also setting up in excel thank you in advance

\fView Insert Format Tools Table Window Help 3 MBA6100 Case Study 2 - Car Insert Draw Design Layout References Makings Review View Tell me Callbri (80.. - 11 . A A A. A - P.A. Here are the Actual Results in January and February: Actual Data: January February Production (Units] 245,000 187.000 Revenue 19,345,000 $ 14,888,000 Raw Materials 7,545,000 5 5,796,000 Packaging Materials 3,928,090 $ 2,997,000 Electricity 1,175,090 842.000 Waste and Other Costs 1,837,000 $ 1,442.000 Worei 575,000 585,000 Fringe Benefits 287,500 792.900 Rent 950,000 950,000 Insurance 60,090 65,090 Depreciation 370,000 340.000 Question 1: Prepare a static budget in Excel for Vroom Vroom based on 209,000 units produced. 5) Show the static budget for January In Contribution Margin Income Statement format. bj Compare January's static budget to January's actual results. Specify which line items are favorable or unfavorable and how much. () For Raw Material Costs and Packaging Costs, break out the Price and Volume Variances for January. Provide potential explanations for each one. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential [made up) reasons. d) Show the static budget for February in Contribution Margin Income Statement format. Compare February's static budget to February's actual results. Specify which line items are favorable or unfavorable and how much. 1) For Raw Material Coute and Packaging Cous, break out the Price and Volume Variances for February, Provide potential explanations for each one. Note: Saying that an item was above or below budget is NOT an caplanation. You need to include potential [made up) reavon Page 2 013 728 words MacBook All