Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help with this problem C D Project #5: CVP Project (100 Points F G H Below is the income Statement for Bikes RUs
i need help with this problem
C D Project #5: CVP Project (100 Points F G H Below is the income Statement for Bikes "R"Us for the Year Ended December 31, 2021 Bikes "R"US Income Statement For the Year Ended December 31, 2021 $ Sales (200,000) Cost of Goods Sold Gross Profit 1.200,000 700,000 500,000 Operating Expenses Selling Administrative Net Loss 300,000 275,000 $ 575.000 (75,000) A cost behavior analysis indicates that 70% of the cost of goods sold are variable, 45% of the seling expenses are variable, and 40% of the administrative expenses are variable Rounding Instructions Round FINAL variable cost to 2 decimals, FINAL break even answers to unit and dollara e no decimals) Format: Prepare parts 2 and 3 in CVP income statement format and show all computations using formulas in excel or google sheets for All calculations PARTI Using the data in the income statement above, compute the break-even point in total sales dollars and in units for 2021 PARTI2 PLANA - Steve, the Accounting Manager has proposed a plan to improve its profitability Steve feels that the quality of the product could be substantially moroved by spending $0.25 more per unit on better raw materials. The selling price per un could be increased to 56.25 Steve estimates that sales volume will increase by 20% Compute net income under Steve's proposal and the break even point in dollars Projects Sheet H Rounding Instructions - Round FINAL variable cost to 2 decimals, FINAL break even answers to unit and dollar (e no decimals) Format: Prepare parts 2 and 3 in CVP income statement format and show all computations using formulas in excel or google sheets for ALL calculations PART1 Using the data in the income statement above, compute the break-even point in total sales dollars and in units for 2021 PART 2 PLANA - Steve, the Accounting Manager, has proposed a plan to improve to profitability Steve feels that the quality of the product could be substantially improved by spending 50 25 more per unit on better raw materials. The seling price per un could be increased to 56.25 Sleve estimates that sales volume wil increase by 205 Compute net income under Steve's proposal and the break-even point in dollars (NOTE DO NOT Round the contribution margin ratio) PARTS PLAN 8-Lisa, was a sales and marketing major in college Lisa beleves that sales volume can be increased only by an intensive advertising and promotional campaign She proposed the following plan as an alternative to Steve's plan: (1) increase variable seling expenses to 0.70 per unt (2) increase the seling price per unt by 50 40. and (3) ncrease foed selling expenses by $50,000 Lisa based her recommendations on an old marketing research report that said that sales volume would increase by 30% if these changes were made. Compute net income under Lisa's proposal and break-even point in dollar (NOTE: DO NOT Round the contribution margin ratio.) PART 4 Which plan do you believe should be accepted and why? Using good written communication, completely and throughly explain your answer UPLOAD YOUR COMPLETED SPREADSHEET TO CANVAS TO SUBMIT YOUR ASSIGNMENT YOU ARE USING A DIFFERENT SPREADSHEET SOFTWARE OTHER THAN MICROSOFT EXCEL CONVERT THE FILE TO A MICROSOFT EXCEL FORMAT BEFORE UPLOADING OR YOU WILL RECEIVE A ZERO FOR THIS PROJECT Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started