Complete the file Acctg 1B chap 5 hw f21 by creating a CVP income statement and use it to work the problems

Also complete a High-Low calculation to find the Cost per unit (variable) and the fixed cost

Use the file on a spreadsheet or pencil/paper

CVP Income Statement Total Per Unit Revenue Variable Cost Contribution Margin percent Fixed Cost Net Income Break even in Units Fixed Cost divided by Contribution Margin per unit Break even in $ Fixed Cost divided by Contribution Margin% CVP Income Statement Total Per Unit Revenue Variable Cost Contribution Margin Fixed Cost Net Income HW Chapter 5 Name Set up CVP income statement and show work here You have a business selling and delivering pizzas to businesses for lunch. You pay $5,000 per month in rent, $400 for utilities, and $3,000 a month for salaries. You also have delivery cars that cost $1,500 per month Your variable costs are $7 per pizza for ingredients and $4 per pizza for delivery costs. You sell the pizzas for $23 each Round up if necessary What is the number of pizzas you need to sell to break even for the month If you want to make a profit of 3,000 per month, how many pizzas do you need to sell? Round up if necessary If the price of cheese goes up and your variable costs go by $3 What is your new break even point if you increase your price to $25 Round up if necessary Golden Company has a fleet of delivery trucks and has the following Overhead costs per month with the miles driven Miles Driven Total Costs March 50,000 194.000 Aprill 40,000 170,200 May 60,000 217,600 June 70,000 241,000 Use the High-Low method to determine the a Variable Cost per Mile b. Fixed Costs