Hello - I know I posted this question already, but I would need help again to solve the assignment above. I need help creating a financial statement in the form of an Excel- or Google Sheet, with the help of all the schedules as stated in the first three tasks. Here are the schedules/figures:

Any help I can get is much appreciated - thank you.

Your assignment is to: 1. Replicate each of the budgets/financial statements presented in Review Problems 9.3, 9.4, 9.5, 9.6 and 9.7 for Carol's Cookies in Google Sheets and submit your work. Title your worksheet Your Name Carols Cookies. 2. Please put all schedules in one tab, running vertically up and down the page. Also keep each schedule distinct, clearly labeled, and separated from the others with white space on your worksheet. Ensure that your formatting looks nice and that you are ready to present your results to the class if called on! 3. In addition, you must gather the key data behind the schedules in a 'Data' block at the top of your worksheet. You must use formulas to link all the tables together and tie them back to your data block. The target is a single worksheet that will correctly recalculate itself from top to bottom if we change some of the assumptions in your data block. SUBMIT YOUR WORKSHEET WITH ALL THE ORIGINAL FIGURES FROM THE TEXT. HOWEVER, TEST your spreadsheet before submitting it! 1. Change the annual growth rate for sales from 25% to 20%. all the subsequent tables through to the budgeted balance sheet should correctly reflect the changes, not only the sales budget! (BUT, see the 'final note' below) Note that this is not a trivial exercise! You will have to understand the interconnections between the schedules quite well to make this work. 2. Change the selling price from $8.00 to $7.90, observe the changes all the way through to your balance sheet. Do the changes flow through all your schedules? 3. Change the desired inventory level in the production budget from 10% to 15%, observe the changes. Do the changes flow through all your schedules? Figure 9.3 Sales Budget for Jerry's Ice Cream Jerry's Ice Cream Sales Budget Year Ending December 31 Quarter 1 2 3 4 Year Sales in units (1 unit = 1 gallon) Sales price per unit Sales revenue 40,000 $6 $240,000 48,000 $6 $288,000 60,000 $6 $360,000 52,000 $6 $312,000 200,000 $6 $1,200,000 Figure 9.4 Production Budget for Jerry's Ice Cream Jerry's Ice Cream Production Budget Year Ending December 31 Quarter 1 2 3 4 Year Sales in units* Add desired ending finished good inventory** Total finished goods inventory needed Deduct beginning finished goods inventory*** Units to be produced 40,000 4,800 44,800 (4,000) 40,800 48,000 6,000 54,000 (4,800) 49,200 60,000 5,200 65,200 (6,000) 52,000 4,400 56,400 (5,200) 51,200 200,000 4,400 204,400 (4,000) 200,400 59,200 Figure 9.5 Direct Materials Purchases Budget for Jerry's Ice Cream Jerry's Ice Cream Direct Materials Purchases Budget Year Ending December 31 Quarter 1 2 3 4 Year Units to be produced Materials required per unit (pounds) Materials needed in production Add desired ending inventory** Materials needed in inventory Deduct beginning inventory*** Direct materials to be purchased (pounds) Cost of materials per pound Cost of materials to be purchased Direct materials cost per unit**** 40,800 X2 81,600 19,680 101,280 (16,320) 84,960 X $1 $84,960 49,200 X2 98,400 23,680 122,080 (19,680) 102,400 X $1 $ 102,400 59,200 X2 118,400 20,480 138,880 (23,680) 115,200 $1 $115,200 51,200 x2 102,400 20,000 122,400 (20,480) 101,920 X $1 $101,920 200,400 x2 400,800 20,000 420,800 (16,320) 404,480 X $1 $404,480 2.00 Figure 9.6 Direct Labor Budget for Jerry's Ice Cream Jerry's Ice Cream Direct Labor Budget Year Ending December 31 Quarter 2 3 4 Year Units to be produced Direct labor hours per unit Total direct labor hours needed in production Labor rate per hour Total direct labor cost Direct labor cost per unit** 40,800 x 0.10 4,080 X $13 $ 53,040 49,200 x 0.10 4,920 X $13 $ 63,960 59,200 x 0.10 5,920 X $13 $ 76,960 51,200 x 0.10 5,120 $13 $ 66,560 200,400 x 0.10 20,040 $13 $260,520 $ 1.30 Figure 9.7 Manufacturing Overhead Budget for Jerry's Ice Cream Jerry's Ice Cream Manufacturing Overhead Budget Year Ending December 31 Quarter 1 2 3 4 Year Units to be produced* 40,800 49,200 59,200 51,200 200,400 Variable overhead costs Indirect materials ($0.15 per unit) Indirect labor ($0.10 per unit) Other ($0.25 per unit) Total variable overhead costs $ 6,120 4,080 10,200 $ 20,400 $ 7,380 4,920 12,300 $ 24,600 $ 8,880 5,920 14,800 $ 29,600 $ 7,680 5,120 12,800 $ 25,600 $ 30,060 20,040 50,100 $100,200 Fixed overhead costs Salaries Rent Depreciation Total fixed overhead costs 15,000 10,000 10,070 $ 35,070 15,000 10,000 10,070 $ 35,070 15,000 10,000 10,070 $ 35,070 15,000 10,000 10,070 $ 35,070 60,000 40,000 40,280 $140,280 Total overhead costs Deduct depreciation Cash payments for overhead Manufacturing overhead per unit** 55,470 (10,070) $ 45,400 59,670 (10,070) $ 49,600 64,670 (10,070) $ 54,600 60,670 (10,070) $ 50,600 240,480 (40,280) $200,200 $ 1.20 Your assignment is to: 1. Replicate each of the budgets/financial statements presented in Review Problems 9.3, 9.4, 9.5, 9.6 and 9.7 for Carol's Cookies in Google Sheets and submit your work. Title your worksheet Your Name Carols Cookies. 2. Please put all schedules in one tab, running vertically up and down the page. Also keep each schedule distinct, clearly labeled, and separated from the others with white space on your worksheet. Ensure that your formatting looks nice and that you are ready to present your results to the class if called on! 3. In addition, you must gather the key data behind the schedules in a 'Data' block at the top of your worksheet. You must use formulas to link all the tables together and tie them back to your data block. The target is a single worksheet that will correctly recalculate itself from top to bottom if we change some of the assumptions in your data block. SUBMIT YOUR WORKSHEET WITH ALL THE ORIGINAL FIGURES FROM THE TEXT. HOWEVER, TEST your spreadsheet before submitting it! 1. Change the annual growth rate for sales from 25% to 20%. all the subsequent tables through to the budgeted balance sheet should correctly reflect the changes, not only the sales budget! (BUT, see the 'final note' below) Note that this is not a trivial exercise! You will have to understand the interconnections between the schedules quite well to make this work. 2. Change the selling price from $8.00 to $7.90, observe the changes all the way through to your balance sheet. Do the changes flow through all your schedules? 3. Change the desired inventory level in the production budget from 10% to 15%, observe the changes. Do the changes flow through all your schedules? Figure 9.3 Sales Budget for Jerry's Ice Cream Jerry's Ice Cream Sales Budget Year Ending December 31 Quarter 1 2 3 4 Year Sales in units (1 unit = 1 gallon) Sales price per unit Sales revenue 40,000 $6 $240,000 48,000 $6 $288,000 60,000 $6 $360,000 52,000 $6 $312,000 200,000 $6 $1,200,000 Figure 9.4 Production Budget for Jerry's Ice Cream Jerry's Ice Cream Production Budget Year Ending December 31 Quarter 1 2 3 4 Year Sales in units* Add desired ending finished good inventory** Total finished goods inventory needed Deduct beginning finished goods inventory*** Units to be produced 40,000 4,800 44,800 (4,000) 40,800 48,000 6,000 54,000 (4,800) 49,200 60,000 5,200 65,200 (6,000) 52,000 4,400 56,400 (5,200) 51,200 200,000 4,400 204,400 (4,000) 200,400 59,200 Figure 9.5 Direct Materials Purchases Budget for Jerry's Ice Cream Jerry's Ice Cream Direct Materials Purchases Budget Year Ending December 31 Quarter 1 2 3 4 Year Units to be produced Materials required per unit (pounds) Materials needed in production Add desired ending inventory** Materials needed in inventory Deduct beginning inventory*** Direct materials to be purchased (pounds) Cost of materials per pound Cost of materials to be purchased Direct materials cost per unit**** 40,800 X2 81,600 19,680 101,280 (16,320) 84,960 X $1 $84,960 49,200 X2 98,400 23,680 122,080 (19,680) 102,400 X $1 $ 102,400 59,200 X2 118,400 20,480 138,880 (23,680) 115,200 $1 $115,200 51,200 x2 102,400 20,000 122,400 (20,480) 101,920 X $1 $101,920 200,400 x2 400,800 20,000 420,800 (16,320) 404,480 X $1 $404,480 2.00 Figure 9.6 Direct Labor Budget for Jerry's Ice Cream Jerry's Ice Cream Direct Labor Budget Year Ending December 31 Quarter 2 3 4 Year Units to be produced Direct labor hours per unit Total direct labor hours needed in production Labor rate per hour Total direct labor cost Direct labor cost per unit** 40,800 x 0.10 4,080 X $13 $ 53,040 49,200 x 0.10 4,920 X $13 $ 63,960 59,200 x 0.10 5,920 X $13 $ 76,960 51,200 x 0.10 5,120 $13 $ 66,560 200,400 x 0.10 20,040 $13 $260,520 $ 1.30 Figure 9.7 Manufacturing Overhead Budget for Jerry's Ice Cream Jerry's Ice Cream Manufacturing Overhead Budget Year Ending December 31 Quarter 1 2 3 4 Year Units to be produced* 40,800 49,200 59,200 51,200 200,400 Variable overhead costs Indirect materials ($0.15 per unit) Indirect labor ($0.10 per unit) Other ($0.25 per unit) Total variable overhead costs $ 6,120 4,080 10,200 $ 20,400 $ 7,380 4,920 12,300 $ 24,600 $ 8,880 5,920 14,800 $ 29,600 $ 7,680 5,120 12,800 $ 25,600 $ 30,060 20,040 50,100 $100,200 Fixed overhead costs Salaries Rent Depreciation Total fixed overhead costs 15,000 10,000 10,070 $ 35,070 15,000 10,000 10,070 $ 35,070 15,000 10,000 10,070 $ 35,070 15,000 10,000 10,070 $ 35,070 60,000 40,000 40,280 $140,280 Total overhead costs Deduct depreciation Cash payments for overhead Manufacturing overhead per unit** 55,470 (10,070) $ 45,400 59,670 (10,070) $ 49,600 64,670 (10,070) $ 54,600 60,670 (10,070) $ 50,600 240,480 (40,280) $200,200 $ 1.20