Prepare the cash budget for the first quarter.

1 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the sales budget for the first quarter. January February March Quarter 3 points Budgeted sales in dozens) 1000 1200 1300 3500 eBook Sales price per dozen 12.05 12.05 12.05 12.05 Print Total sales 12050 14460 References 15665 42175.00 3 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) materials budget for flour for the first quarter. prepare the direct 9 points January February March Dozens of cookies to be produced Quarter 3500 1000 1200 1300 Cups per dozen cookies eBook 2.50 2.50 2.50 2.50 Production needs Print 2500.00 3000.00 3250.00 8750 Add: Desired ending inventory References 300.00 325.00 275.00 275 Total needs 2800.00 3325.00 3525.00 9025 01 300.00 325.00 0 Less: Beginning inventory Cups to be purchased Cost per cup Total cost of flour 2800 3025 3200 9025 0.15 0.15 0.15 0.15 420 453.75 480 1353.75 4. Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the direct materials budget for all types of sugar for the first quarter. 9 points January February March Quarter 3500 1000 1200 1300 eBook 1.5 1.5 1.5 1.5 Print 1500 1800 1950 5250 References 180 165 165 Dozens of cookies to be produced Cups per dozen cookies Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Cups to be purchased Cost per cup Total cost of sugar 195 1995 1680 2115 5415 0 195 0 1680 180 1815 0.15 1920 0.15 0.15 288 5415 0.15 81225 252 272.25 5 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the direct materials budget for eggs for the first quarter 9 points January February March Quarter 1000 1200 1300 3500 eBook 2 2 2 2 Print 2000 2400 Dozens of cookies to be produced Eggs per dozen cookies Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Eggs to be purchased 2600) 7000 References 240 260 220 220 2240 2660 2820 7220 0 240 260 0 2240 2420 2560) 7220 Cost per egg Total cost of eggs 0.1 0.1 0.1 224 0.1 256 2421 722 6 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the direct materials budget for shortening for the first quarter. points January February March Quarter Dozens of cookies to be produced 1000 1200 1300 3500 eBook Cups per dozen cookies 1 1 Print Production needs 1000 1200 1300 3500 References Add: Desired ending inventory 120 130 110 110 Total needs 1120 1330 1410 3610 Less: Beginning inventory 0 120 130 0 Cups to be purchased 11201 12101 1280 3610 Cost per cup 0.5 0.51 0.5 0.5 Total cost of shortening 560 605 640 1805 7 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the direct materials budget for chocolate chips for the first quarter. 9 points January February March Quarter Dozens of cookies to be produced 1000 1200 1300 3500 eBook Cups per dozen cookies 2 2 2 2 Print Production needs 2000 2400 2600 7000 References Add: Desired ending inventory 240 260 220 220 Total needs 2240 26607 2820 7220 Less: Beginning inventory 0 240 260 0 Cups to be purchased 2240 2420 2560 7220 Cost per cup 125 1.25 1.25 125 Total cost of chocolate chips 2800 3025 3200) 9025 8 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the cash disbursements for direct materials budget for the first quarter. 8 points January February March Quarter eBook January disbursements 1064 3192 0 4256 Print February disbursements 0 References 1149.50 3448.50 4598 March disbursements 0 0 1216 1216 Total cash disbursements for materials 1064 4341.50 4664.50 10070 Check 9 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the manufacturing overhead budget for the first quarter. 3 points January February March Quarter Dozens of cookies to be produced 1000 1200 1300 3500 eBook Nariable manufacturing overhead per dozen 1.25 125 1.25 125 Print Budgeted variable manufacturing overhead 1250 1500 1625 4375 References Budgeted fixed manufacturing overhead 750 750 750 2250 Total budgeted manufacturing overhead 2000 2250 2375 6625 Less: Noncash costs 500 500 500 1500 Cash disbursements for manufacturing overhead 1500 1750 1875 5125 Use the information provided in the Master Budget assignment prompt (posted in Canvas under Week 10) to prepare the cash budget for the first quarter January February March Quarter Beginning cash balance 10000 25000 1001762 Add: Cash collections Total cash available Less: Disbursements Direct materials Manufacturing overhead Operating expenses Equipment purchases Total disbursements Excess (deficiency) of cash Financing Borrowings Repayments Interest Total financing Ending cash balance Sweetums Cookies, Inc.: A Master Budget Case Introduction You knew they were good, but you never thought Grandma's old cookie recipe would bring you this far! It all started about three years ago when you began using your Grandma's cookie recipe to bake cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has been great! People love the cookies, and you're making a little extra money. There is a small problem with all of this success. The volume of business has grown so much that you can no longer keep up with demand. Your desire to grow this hobby into a full-fledged business has led you to explore expanding. You have been investigating new facilities, equipment, and the requirements of hiring a few employees. However, you're missing one important element; money to fund this expansion! On the advice of a friend, you meet with a local banker. She says that the bank cannot lend you any money without a business plan that describes your financial results, marketing strategy, and projections for the future. You show the banker your income statement and balance sheet as of the most recent year-end, but what she really needs to see is your budget for the next year. When you return home after the meeting, you pull out your college accounting textbook and settle in to produce a plan for next year. You pull out Grandma's recipe to see what ingredients it takes to make a dozen cookies. Next, you go to your invoice files to determine the cost of each of the ingredients. You brainstorm to develop a list of the new costs that you must incur when you expand your operations. After analyzing all of this data you are able to break your costs into several categories. You realize that some costs are for raw materials while others are related to manufacturing overhead or operating expenses. You also realize that some costs appear to be fixed while other costs are variable. You now have the information you need to create a budget that will allow you to show the banker your plans for the coming year. This budget will also help you to understand your sales and the collection on those sales. You will be able to determine how much money you need to purchase the ingredients for your cookies and to pay your overhead and operating expenses. You realize that if you can estimate how many dozens of cookies you can sell, then you can calculate how many ingredients to buy and how much overhead and operating expenses will be. You will need to get yours sales estimate as accurate as possible. This project is based loosely on a moster budget case developed by Thomas Wooten and tone Dard-Egers of Belmont University Assignment Use the information in Exhibits 1 - 3 to prepare a master budget for the first quarter of the year (January - March). Exhibit 1 presents information regarding sales price, production costs, and operating costs. Exhibit 2 contains information regarding your sales projections, expected collection patterns, purchasing and payment patterns for the first four months of the year. Exhibit 3 presents information regarding your plans for capital contributions, equipment purchases, loans, minimum cash balance. It also contains your Grandma's cookie recipe. Required Complete the Connect assignment Master Budget Project by preparing the following components of Sweetums Inc.'s master budget: 1.) Sales budget 2.) Cash collections budget 3.) Direct materials purchases budgets (5) 4.) Cash disbursements for materials budget 5.) Manufacturing overhead budget 6.) Operating expenses budget 7.) Cash budget EXHIBIT 1 Sales Price, Production Costs, and Operating Expenses Sales Price A dozen cookies sell for $12.05. Direct Materials Costs Material Flour Sugar Eggs Shortening Chocolate Chips Per Unit Cost $ .15 $ .15 $.10 $ .50 $ 1.25 Any other ingredients are indirect materials and are considered part of manufacturing overhead Direct Labor Costs Information regarding direct labor costs is not maintained because you are your only employee. In this case, labor costs are considered part of manufacturing overhead. Manufacturing Overhead Costs Utilities Other indirect materials and labor Maintenance Depreciation Totals Variable costs per dozen $.50 $.75 N/a N/a $ 1.25 Fixed costs per month N/a N/a $ 250 $ 500 $ 750 Operating Expenses Shipping Costs Salaries Depreciation Other Totals Variable costs per dozen $ 1.50 N/a N/a N/a $ 1.50 Fixed costs per month N/a $ 2,000 $ 200 $ 1,450 $ 3,650 This project is based loosely on a master budget cose developed by Thomas Water and some biors-Eppes et Animont cerita EXHIBIT 2 Sales Projections, Collections, Purchases, and Payments Monthly Sales Projections (in dozens of cookies): January February March April 1,000 1,200 1,300 1,100 You have stopped production of cookies at year end to facilitate the expansion of the business. Therefore, you expect to have no uncollected accounts receivable, unpaid accounts payable, or raw materials inventories at January 1, the beginning of your budget period. Collections of Sales Sixty percent (60%) of all sales are collected in the month the sale occurs. Forty percent (40%) of all sales are collected in the month following the sale. Production The company produces cookies daily. No work-in-process or finished goods inventories are maintained. Raw Materials Inventory, Purchases, and Payments The company plans to maintain an ending inventory of raw materials at the end of each month equal to 10% of the raw materials production needs for the next month. Twenty-five percent (25%) of materials purchases are paid for in the month of the purchase. Seventy- five percent (75%) of materials purchases are paid for in the month following the purchase. EXHIBIT 3 Financing Activities and Cookie Ingredients Financing Activities January beginning cash balance $10,000 Loan acquired in January $25,000 Equipment purchase in January $20,000 Minimum desired cash balance at the end of each month $10,000 If cash over $10,000 is available at the end of the month, you will make repayments of outstanding loans in multiples of $1,000. If additional borrowing is necessary to maintain the $10,000 end-of-month balance, you have a line of credit with the bank and will borrow additional funds in multiples of $1,000 Interest (12% annual rate) is paid monthly on total outstanding borrowing at the end of the prior month. Sweetums Cookie Ingredient List (makes 1 dozen cookies) 2 % cups flour 1% cups sugar 1 cup shortening 2 cups chocolate chips 2 eggs 1% teaspoons vanilla 1 teaspoon baking soda 1 teaspoon salt