Calculate the following rations using the information below for the current month. It must be completed on Google Sheets or Excel. Let's assume that Fresno California Corporation sells its merchandise for $120 per unit. The variable cost per unit is $30. Fixed expenses for the company are $18,000 per month. The expected sales for the current month are to be $32,000. 1. Contribution Margin 2. Contribution margin ratio 3. Unit sales to break-even 4. Dollar sales to break-even 5. Margin of safety in dollars **Estimated time to complete - 25 minutes See the video if you need guidance or you may always search Excel or Google Sheets features on Youtube.

Calculate the following rations using the information below for the current month. It must be completed on Google Sheets B or Excel. Let's assume that Fresno California Corporation sells its merchandise for $120 per unit. The variable cost per unit is $30. Fixed expenses for the company are $18,000 per month. The expected sales for the current month are to be $32,000 1. Contribution Margin 2. Contribution margin ratio 3. Unit sales to break-even 4. Dollar sales to break-even 5. Margin of safety in dollars "Estimated time to complete - 25 minutes See the video if you need guidance or you may always search Excel or Google Sheets features on Youtube. Sales Budget information: Fresno California Company plans to sell 3,000 pots and pans sets for the first quarter of this year. The sales volume is expected to increase by 5% each quarter for the remainder of the calendar year. The selling price of the pots and pans is $199 per set and will decrease by 10% in the fourth quarter. For simplicity, assum that all of the sales are cash sales. Production Budget information: Using the Sales Budget results, the FCC, Inc. had 200 sets of pots and pans in finished goods inventory at the end of the previous year, so we can use that number as we start our production budget. We also want to always have at least 150 sets in our finished goods inventory at the end of each quarter, but we would like to end the year with 250 sets in inventory to start the following year. Requirements: 1. Use this Google Sheets file E, template, save an editable copy to your Google Drive, and use the information above to prepare the following operating budgets (or create your own file using MS Excel): 1. Sales Budget 2. Production Budget 2. Save and download the file as an Excel file 3. Submit your assignment fle through Canvas, and you are done! "Estimated time to complete - 25 minutes See the video if you need guidance or you may always search Excel or Google Sheets features on Youtube