Our controller, Richard Kimmel is negotiating with potential new Clay suppliers
ID: 2467200 • Letter: O
Question
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, 2017 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, 2017.
The deliverables are as follows:
Sales budget, including a schedule of expected cash collections.
Production budget.
Direct materials budget, including a schedule of expected cash disbursements for materials.
Direct labor budget.
Manufacturing overhead budget.
Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of June 30, 2017.*
Selling and administrative expense budget.
Cash budget.
Budgeted income statement for the year ended June 30, 2017.*
Budgeted balance sheet for June 30, 2017.*
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 April [ ], 2016. You can print more than one schedule per page, but do not have a page break in the middle of a budget schedule. I like to be 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 e-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. Send the Excel spreadsheet as an email attachment. We need that spreadsheet file by April [ ], 2016 as well.
I’ve attached a brief description of the Large Gnome Division to the budget data Richard gave me before he left for Kentucky. We eagerly await your results.
Sincerely,
Candice Kimmel
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 until it is hard. Once cooled, the gnome is painted to the level of detail desired. German manufacturers disappeared during WWII. Post World War II, gnome 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. Griebel'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 quality clay garden gnomes that are hand finished. Kimmel Gnomes are stoneware, rather than terracotta. Stoneware uses higher-quality clay than terracotta and the gnomes 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 being painted after firing. As a result Kimmel 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 length or height (the “Hedgerow Gnome” model is shown in the picture to the left). Many different styles are made, but each large gnome requires virtually the same amount of time and materials.
During 2016-17 fiscal year, the average selling price for large gnomes is expected to be $114 per gnome. The Large Gnome Division forecasts the following number gnome sales.
Quarter First Second _ Third Fourth
Gnome sales 45,000 82,000 42,000 76,000
The collection pattern for Accounts Receivable is as follows:
70 percent of all sales are collected within the quarter in which they are sold
30 percent of all sales are collected in the following quarter.
There are no bad debts/uncollectibles.
Due to higher than expected demand this year, the Large Gnome Division expects to have no finished gnomes in inventory on July 1, 2016, the beginning of the first quarter of the new fiscal year. To avoid having that problem in the coming fiscal year, the Large Gnome Division would like to have the ending inventory of Gnomes at the end of each of the first three quarters equal to 25% of the budgeted sales for the next quarter. They would like to have 22,500 finished gnomes on hand on June 30, 2017.
Quarter First Second _ Third Fourth
Ending FG inventory in Gnomes
as a % of the next quarter’s
budgeted sales 25% 25% 25% ?
Ending FG inventory in Gnomes ? ? ? 22,500
Each large gnome requires an average of 4 pounds of clay. The Large Gnome Division buys clay for $0.95 per pound and they expect the price to remain constant throughout the year. They expect to have 70,000 pounds of clay on hand as of July 1, 2016, the beginning of the first quarter of the fiscal year. At the end of each of the first three quarters, the Large Gnome Division would like to have their direct materials inventory quantity to equal 35 percent of the amount required for the following quarter’s planned production. On June 30, 2017, the end of the fiscal year, Large Gnome Division would like to have 110,000 pounds of clay on hand.
Quarter First Second _ Third Fourth
Ending DM inventory as a %
of the next quarter’s
production requirement 35% 35% 35% ?
Ending DM inventory in pounds ? ? ? 110,000
The Large Gnome Division buys its clay on account. It pays for 40% of its purchases of direct materials in the quarter in which they were purchased and 60% in the quarter after they were purchased.
Each large gnome requires 3.00 hours (180 minutes) of direct labor. Employees engaged in direct labor will be paid an estimated $15.00 per labor hour. Wages and salaries are paid on the 15th and 30th of each month.
Variable manufacturing overhead is estimated to be $11.00 per direct labor hour for the coming fiscal year. All variable manufacturing overhead expenses are paid for in the quarter incurred.
Fixed manufacturing overhead is estimated to total $330,000 each quarter, with $190,000 out of the total amount of $330,000 representing depreciation on machinery, equipment and the factory. All other fixed manufacturing overhead expenses are paid in cash in the quarter they occur. The fixed manufacturing overhead rate will be computed by dividing the year’s total fixed manufacturing overhead by the year’s budgeted direct labor hours. Round the fixed overhead rate to the nearest penny.
Variable selling and administrative expenses are estimated to be $14.00 per gnome sold. Fixed selling and administrative expenses are expected to total $90,000 each quarter, with $25,000 out of the total amount of $90,000 representing depreciation on the office space, furniture and equipment. Other than depreciation, all selling and administrative expenses are paid for in the quarter they occur.
On June 30, 2017 the Large Gnome Division plans to buy new machinery and equipment for $1,900,000. The new machinery and equipment will be acquired at the very end of the year, so it will not be used in production and sales during the coming year and it will not be depreciated until the following year. The Large Gnome Division expects to pay 25% down and finance the remaining 75% of the equipment cost with a note payable. No interest payable will accrue on the equipment note payable until after June 30, 2017.
Large Gnome Division must maintain a minimum cash balance of $50,000. If after accounting for cash receipts and disbursements (including dividends) in the cash budget, the budgeted cash available cash falls below $50,000 in any quarter, the Large Gnome Division will need to borrow cash. The Large Gnome Division has arranged a line of credit allowing it to borrow in $10,000 increments. Assume borrowing will take place at the beginning of any quarter in which the available cash would otherwise be below $50,000 so that at no time during the quarter will the cash balance fall below $50,000. The bank charges the Large Gnome Division interest at the rate of 1.0% per quarter (not compounded). On June 30, 2017, the Large Gnome Division will pay any interest due for 2016-17 on their line of credit. They will also repay the principal balance on the line of credit if they have sufficient cash to do so.
As a fully owned subsidiary, the Large Gnome Division does not pay income taxes. All income taxes are charged to Kimmel Gnomes, the parent company. Large Gnome Division will pay dividends of $25,000 each quarter to its corporate parent, Kimmel Gnomes. The dividends must be paid, even if the Large Gnome Division has to borrow on its line of credit to make the payment
The budgeted balance sheet for the Large Gnome Division on June 30, 2016 (which is the same as the budgeted balance sheet at the beginning of business July 1, 2016) is presented below. Kimmel Gnomes owns 100% of the Capital Stock of the Large Gnome Division.
LARGE GNOME DIVISION – KIMMEL GNOMES
BUDGETED BALANCE SHEET
JUNE 30, 2016
ASSETS
LIABILITIES & EQUITY
Cash
$214,000
Accounts Payable
$96,000
Accounts Receivable
1,250,000
Notes Payable
0
Raw Material Inventory
66,500
Capital Stock
31,600,000
Plant and Equipment
32,500,000
Retained Earnings
2,334,500
TOTAL ASSETS
$34,030,500
TTL LIAB. & SE
$34,030,500
Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of June 30, 2017.*
LARGE GNOME DIVISION – KIMMEL GNOMES
BUDGETED BALANCE SHEET
JUNE 30, 2016
ASSETS
LIABILITIES & EQUITY
Cash
$214,000
Accounts Payable
$96,000
Accounts Receivable
1,250,000
Notes Payable
0
Raw Material Inventory
66,500
Capital Stock
31,600,000
Plant and Equipment
32,500,000
Retained Earnings
2,334,500
TOTAL ASSETS
$34,030,500
TTL LIAB. & SE
$34,030,500
Explanation / Answer
Answer:
Sales budget Quarter First Second Third Fourth Unit sales 45000 82000 42000 76000 Unit price 114 114 114 114 Sales ($) 5130000 9348000 4788000 8664000 Schedule of Expected Cash Collections Quarter First Second Third Fourth 70% sales are collected in the Quarter in which they are sold 3591000 6543600 3351600 6064800 30% are collected in following Quarter 1250000 1539000 2804400 1436400 Total cash collections 4841000 8082600 6156000 7501200Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.