AT&T 10:11 PM a ccsu.blackboard.com Our controller, Richard Kimmel is negotiating with potential new Clay suppliers in Kentucky. We need the Large Gnome Division's Master Budget for the fiscal year ended June 30, 2019 for our corporate strategic planning process, and we cannot wait for Richard's return from Kentucky. We would like you to prepare the Large Gnome Division's Master Budget for the fiscal year ended June 30, 2019 The deliverables are as follows . Sales budget, including a schedule of expected eash collections 2. Production budget. 3. Direct materials budget, including a schedule of expected cash disbursements for materials. 4. Direct labor budget. . Manufacturing overhead budget 6. Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of June 30, 2019. 7. Selling and administrative expense budget. 8. Cash budget. 9. Budgeted income statement for the year ending June 30. 2019.* 10. Budgeted balance sheet for June 30, 2019.* All the Master Budget schedules except those marked with an asterisk for the Large Gnome Division should include a column for each quarter and a total column for the fiscal year. We only need annual totals for the budgeted financial statements (schedules 9 and 10) and we only need a year-end total for the value of finished goods inventory (schedule 6). The hard copies of these budget schedules should be delivered by the company deadline. You can print more than one schedule per page, bu able to view an entire budget schedule without flipping back and forth between pages. Please also use a type font of between 10-12 points for printing. We also need you to submit (via c-mail) the Excel spreadsheet that you used to create the budget schedules you print so we can use the spreadsheet as a starting point for future budgets. Upload the Excel spreadsheet on Blackboard. We need that sprcadsheet file the night before the meeting I've attached a brief deseription of the Large Gnome Division tote budget data Richard gave me before he left for Kentucky. Wc cagerly await your results. Sincercly Candice Kimmel Kimmel Gnomes The garden gnomes were first produced in volume made in the German town of Graefenroda by Phillip Griebel back in the mid-1800s. Garden gnomes quickly became popular, and their use as a garden ornament spread from Germany into France and England. With the spreading popularity of garden gnomes, numerous gnome manufacturers sprang up throughout Germany, with each manufacturer developing their own particular style and design. Traditional gnomes were made from terracotta clay slurry poured into molds. The gnome is removed from the mold, allowed to dry, and then fired in a kiln unti it is hard. Once cooled, the gnome is painted to the level of dctail desired. German manufacturers disappeared during WWIL. Post World War II. gnomc production moved to lower cost countries and lower cost processes and materials were used. Most modern gnomes are made from plastic resins using injection molds rather than terracotta. Gricbel's descendants are the last remaining German producers, and they are last producers making the traditional terracotta garden gnomes Kimmel Gnomes, located in South Dakota, may be the only other manufacturer of high qality clay garden gnomes that are hand finished. Kimmel Gnomes are stoneware, rather than terracotta. Stoneware uses higher-quality clay than terracotta and the gomes are fired at higher temperature, yielding a stronger, more durable gnome. The gnomes are fired inside and out and are colored with glaze before firing, rather than It Kimmel l gnomes retain their color when exposed to the elements and they are not affected by moisture or freezing. The Large Gnome Division manufactures and sells gnomes between 12 and 15 inches in lengthor height (the "Hedgerow Gnome model is shown in the picture to the lef). Many different styles are made, but each large gnome re materials quires virtually the same amount of time and AT&T 10:11 PM a ccsu.blackboard.com Our controller, Richard Kimmel is negotiating with potential new Clay suppliers in Kentucky. We need the Large Gnome Division's Master Budget for the fiscal year ended June 30, 2019 for our corporate strategic planning process, and we cannot wait for Richard's return from Kentucky. We would like you to prepare the Large Gnome Division's Master Budget for the fiscal year ended June 30, 2019 The deliverables are as follows . Sales budget, including a schedule of expected eash collections 2. Production budget. 3. Direct materials budget, including a schedule of expected cash disbursements for materials. 4. Direct labor budget. . Manufacturing overhead budget 6. Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of June 30, 2019. 7. Selling and administrative expense budget. 8. Cash budget. 9. Budgeted income statement for the year ending June 30. 2019.* 10. Budgeted balance sheet for June 30, 2019.* All the Master Budget schedules except those marked with an asterisk for the Large Gnome Division should include a column for each quarter and a total column for the fiscal year. We only need annual totals for the budgeted financial statements (schedules 9 and 10) and we only need a year-end total for the value of finished goods inventory (schedule 6). The hard copies of these budget schedules should be delivered by the company deadline. You can print more than one schedule per page, bu able to view an entire budget schedule without flipping back and forth between pages. Please also use a type font of between 10-12 points for printing. We also need you to submit (via c-mail) the Excel spreadsheet that you used to create the budget schedules you print so we can use the spreadsheet as a starting point for future budgets. Upload the Excel spreadsheet on Blackboard. We need that sprcadsheet file the night before the meeting I've attached a brief deseription of the Large Gnome Division tote budget data Richard gave me before he left for Kentucky. Wc cagerly await your results. Sincercly Candice Kimmel Kimmel Gnomes The garden gnomes were first produced in volume made in the German town of Graefenroda by Phillip Griebel back in the mid-1800s. Garden gnomes quickly became popular, and their use as a garden ornament spread from Germany into France and England. With the spreading popularity of garden gnomes, numerous gnome manufacturers sprang up throughout Germany, with each manufacturer developing their own particular style and design. Traditional gnomes were made from terracotta clay slurry poured into molds. The gnome is removed from the mold, allowed to dry, and then fired in a kiln unti it is hard. Once cooled, the gnome is painted to the level of dctail desired. German manufacturers disappeared during WWIL. Post World War II. gnomc production moved to lower cost countries and lower cost processes and materials were used. Most modern gnomes are made from plastic resins using injection molds rather than terracotta. Gricbel's descendants are the last remaining German producers, and they are last producers making the traditional terracotta garden gnomes Kimmel Gnomes, located in South Dakota, may be the only other manufacturer of high qality clay garden gnomes that are hand finished. Kimmel Gnomes are stoneware, rather than terracotta. Stoneware uses higher-quality clay than terracotta and the gomes are fired at higher temperature, yielding a stronger, more durable gnome. The gnomes are fired inside and out and are colored with glaze before firing, rather than It Kimmel l gnomes retain their color when exposed to the elements and they are not affected by moisture or freezing. The Large Gnome Division manufactures and sells gnomes between 12 and 15 inches in lengthor height (the "Hedgerow Gnome model is shown in the picture to the lef). Many different styles are made, but each large gnome re materials quires virtually the same amount of time and