Excel Assigment

Bleeter's Ice Cream Excel Assignment #2: 30 points Note: Please read through the assignment below. Once you've read the assignment, download the Bleezers Budget spreadsheet from Moodle and consider keeping this file open or printing a copy of the assignment below while working to complete the spreadsheet. Grading When compiling your assignment, consider the following: You will be graded on the execution of formulas in your spreadsheet hard coded numbers receive zero points. Formatting will also be part of the grade - much of the formatting is already complete, so a good rule of thumb is to leave the formatting alone unless it makes sense to do otherwise. Accounting - the numbers must be correct to receive full credit. This is an individual assignment. Your spreadsheet will be audited - which means I will grade by doing more than just making sure your numbers look correct. Due Dates: April 18h-Trailhead: Resume & Career Essay April 28th - Excel 2: Bleezer's Budget Bleezer's Budgeting Assignment 2022: Use the details below to complete the Bleczer Budget spreadsheet. Upload your spreadsheet to Moodle by the due date above. Note: There will not be spreadsheet content/questions on any exam, but the accounting content of this assignment is a very useful study aid for budgeting topics on Exam 2. Details: Your friend, Bleezer, loves ice cream and wants to start their own business: Bleezer's Ice Cream Store. Using the information below, help Bleezer by creating pro forma financial statements and all the supporting budget schedules necessary to generate such a master budget. a. Bleezer's Ice Cream will start business on April 1. Each unit of ice cream will be sold for $2.50 and Bleezer expects to sell 1.000 units, 2,000 units, and 15,000 units in April, May, and June, respectively, Bleezer's Ice Cream only accepts cash at the time of purchase. b. To make sure Bleezer's doesn't experience a stockout, the company will produce an additional 10% beyond expected sales volume each month. Tip: production units = (1.10. sales units) c. There are 2 raw materials at Bleezer's and all purchases are paid for immediately with cash: 1. Milk: each finished good requires 0.02 gallons of milk. Milk costs $3 per gallon. 2. Sugar: each finished good requires 0.008 pounds of sugar. Sugar costs $0.50 per pound. d. It takes an ice cream production specialist 6 minutes to make one unit of Bleczer's Ice Cream - that's 10% of an hour Currently, Bleezer's pays their employees $15 per hour. Employees are paid in cash at the end of every day. Tip: DL costs for one unit = (1 hr* 1 unit) * S15 per hr e. Bleezer thinks the number of labor hours drive the amount of electricity (overhead) used each period. Bleezer estimates the total electricity bill for April, May, and June combined will be $158. f. Bleezer plans to be paid $2,000 in cash cach month for CEO compensation. Additionally, Bleezer's will spend $0.25 per projected sales unit on advertising, paying in cash each month. g. For the sake of keeping this problem massively simple, let's assume Your friend, Bleezer, is a wizard from another dimension and has the magical power to perfectly predict overhead!!! This means... 1. Applied OH = Actual OH (which doesn't happen in real life!) 2. There is no adjustment to COGS for under-/over-applied OH 3. And we're paying cash at the end of each month for exactly the amount that was predicted for the electricity bill (OH). Bleeter's Ice Cream Excel Assignment #2: 30 points Note: Please read through the assignment below. Once you've read the assignment, download the Bleezers Budget spreadsheet from Moodle and consider keeping this file open or printing a copy of the assignment below while working to complete the spreadsheet. Grading When compiling your assignment, consider the following: You will be graded on the execution of formulas in your spreadsheet hard coded numbers receive zero points. Formatting will also be part of the grade - much of the formatting is already complete, so a good rule of thumb is to leave the formatting alone unless it makes sense to do otherwise. Accounting - the numbers must be correct to receive full credit. This is an individual assignment. Your spreadsheet will be audited - which means I will grade by doing more than just making sure your numbers look correct. Due Dates: April 18h-Trailhead: Resume & Career Essay April 28th - Excel 2: Bleezer's Budget Bleezer's Budgeting Assignment 2022: Use the details below to complete the Bleczer Budget spreadsheet. Upload your spreadsheet to Moodle by the due date above. Note: There will not be spreadsheet content/questions on any exam, but the accounting content of this assignment is a very useful study aid for budgeting topics on Exam 2. Details: Your friend, Bleezer, loves ice cream and wants to start their own business: Bleezer's Ice Cream Store. Using the information below, help Bleezer by creating pro forma financial statements and all the supporting budget schedules necessary to generate such a master budget. a. Bleezer's Ice Cream will start business on April 1. Each unit of ice cream will be sold for $2.50 and Bleezer expects to sell 1.000 units, 2,000 units, and 15,000 units in April, May, and June, respectively, Bleezer's Ice Cream only accepts cash at the time of purchase. b. To make sure Bleezer's doesn't experience a stockout, the company will produce an additional 10% beyond expected sales volume each month. Tip: production units = (1.10. sales units) c. There are 2 raw materials at Bleezer's and all purchases are paid for immediately with cash: 1. Milk: each finished good requires 0.02 gallons of milk. Milk costs $3 per gallon. 2. Sugar: each finished good requires 0.008 pounds of sugar. Sugar costs $0.50 per pound. d. It takes an ice cream production specialist 6 minutes to make one unit of Bleczer's Ice Cream - that's 10% of an hour Currently, Bleezer's pays their employees $15 per hour. Employees are paid in cash at the end of every day. Tip: DL costs for one unit = (1 hr* 1 unit) * S15 per hr e. Bleezer thinks the number of labor hours drive the amount of electricity (overhead) used each period. Bleezer estimates the total electricity bill for April, May, and June combined will be $158. f. Bleezer plans to be paid $2,000 in cash cach month for CEO compensation. Additionally, Bleezer's will spend $0.25 per projected sales unit on advertising, paying in cash each month. g. For the sake of keeping this problem massively simple, let's assume Your friend, Bleezer, is a wizard from another dimension and has the magical power to perfectly predict overhead!!! This means... 1. Applied OH = Actual OH (which doesn't happen in real life!) 2. There is no adjustment to COGS for under-/over-applied OH 3. And we're paying cash at the end of each month for exactly the amount that was predicted for the electricity bill (OH)