Our controller, Tommy Swain is negotiating with potential new Wood suppliers in Kentucky. We need the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Our controller, Tommy Swain is negotiating with potential new Wood suppliers in Kentucky. We need the Large Box Car Division's Master Budget for the fiscal year ended June 30, 2021 for our corporate strategic planning process, and we cannot wait for Tommy's return from Kentucky. We would like you to prepare the Large Box Car Division's Master Budget for the fiscal year ended June 30, 2021. The deliverables are as follows: 1. Sales budget, including a schedule of expected cash collections. 2. Production budget. 3. Direct materials budget, including a schedule of expected cash disbursements for materials. 4. Direct labor budget. 5. Manufacturing overhead budget. 6. Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of June 30, 2021. * 7. Selling and administrative expense budget. 8. Cash budget. 9. Budgeted income statement for the year ended June 30, 2021. * 10. Budgeted balance sheet for June 30, 2021. All the Master Budget schedules except those marked with an asterisk for the Large Box Car 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). Tommy's Box Cars DATE: June 1, 2020 CCSU Consulting то: FROM: Mark Swain, President, Tommy's Box Cars SUBJECT: Master Budget for the fiscal year July 1, 2020 - June 30, 2021 Tommy's Box Cars During 2019-20 fiscal year, the average selling price for large box cars is expected to be $130 per car. The Large Box Car Division forecasts the following units of sales. Third Quarter Box Car UNIT Sales First 65,000 Second 70,000 Fourth 60,000 55,000 The collection pattern for Accounts Receivable is as follows: • 30 percent of all sales are collected within the quarter in which they are sold . 70 percent of all sales are collected in the following quarter. There are no bad debts/uncollectible accounts. Due to high demand last year, the Large Box Car Division expects to have zero finished box cars in inventory on July 1, 2020, the beginning of the first quarter of the new fiscal year (I.e. Beginning Finished Goods Inventory is Zero). To avoid having that problem in the coming fiscal year, the Large Box Car Division would like to have the ending inventory of Box Car at the end of each of the first three quarters equal to 30% of the budgeted sales for the next quarter. They would like to have 35,000 finished Box Cars on hand on June 30, 2021. Quarter First Second Third Fourth Ending FG inventory of Box Cars as a % of the next quarter's budgeted sales 30% 30% 30% ? Ending FG inventory of Box Cars ? ? 35,000 Each large box car requires an average of 5.0 feet of wood. The Large Box Car Division buys wood for $4.00 per foot and they expect the price to remain constant throughout the year. They expect to have 50,000 feet of wood (RAw MATERIALS) on hand as of July 1, 2019 ( 50,000 * $4.00 = $200,000 - This is beginning Direct Material Inventory), the beginning of the first quarter of the fiscal year. At the end of each of the first three quarters, the Large Box Car Division would like to have their direct materials inventory quantity to equal 25 percent of the amount required for the following quarter's planned production. On June 30, 2020, the end of the fiscal year, Large Box Car Division would like to have 60,000 feet of wood on hand (This is ending Direct Material Inventory). Quarter First Second Third Fourth Ending DM inventory as a % of the next quarter's production requirement Ending DM inventory in feet 25% 25% 25% ? 60,000 The Large Box Car Division buys its wood on account. It pays for 35% of its purchases of direct materials in the quarter in which they were purchased and 65% in the quarter after they were purchased. Each large box car requires 5 hours of direct labor. Employees engaged in direct labor will be paid an estimated $10.00 per labor hour. Wages and salaries are paid on the 15th and 30th of each month. Variable manufacturing overhead is estimated to be $4.50 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 $120,000 each quarter, with $40,000 out of the total amount of $120,000 representing depreclation on machinery, equipment and the factory. All other fixed manufacturing overhead expenses are paid in cash in the quarter they occur. The fixed manufacturing Tommy's Box Cars 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 $12.00 per box car sold. Fixed selling and administrative expenses are expected to total $95,000 each quarter, with $30,000 out of the total amount of $95,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, 2020 the Large Box Car Division plans to buy new machinery and equipment for $1,000,000. The new machinery and equipment will be acquired at the very end of the fiscal 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 Box Car Division expects to pay 40% down in cash and finance the remaining 60% of the equipment cost with a note payable from a local bank with whom they do business with. No interest payable will accrue on the equipment note payable until after (33) June 30, 2020. The Division must maintain a minimum cash balance of $100,000. If after accounting for cash receipts and disbursements (including dividends) in the cash budget, the budgeted cash available cash falls below $100,000 in any quarter, the Division will need to borrow cash. They have arranged a line of credit allowing it to borrow in $10,000 increments (i.e. they can borrow $10,000 or $20,000 etc. but not an odd amount). Assume borrowing will take place at the beginning of any quarter in which the available cash would otherwise be below $100,000 so that at no time during the quarter will the cash balance fall below $100,000 (after payment of interest). If there is extra cash at the end of the quarter and there is borrowing outstanding, the division should pay down principal (also in increments of $10,000). The bank charges the Division interest at the rate of 3% per quarter. Interest accrued in the quarter will be paid the first day of the next quarter (e.g. Q1's interest is not paid in cash until Q2 and Q2's Interest will be paid in Q3). As a fully owned subsidiary, the Large Box Car Division does not pay income taxes. All income taxes are charged to Tommy's Box Car's, the parent company. Large Box Car Division will pay dividends of $50,000 each quarter to its corporate parent, Tommy's Box Car's. The dividends must be paid, even if the Large Box Car Division has to borrow on its line of credit to make the payment The budgeted balance sheet for the Large Box Car Division on June 30, 2020 (which is the same as the budgeted balance sheet at the begining of business July 1, 2020) is presented below. Tommy's Box Cars owns 100% of the Capital Stock of the Large Box Car Division. LARGE BOX CAR DIVISION – TOMMY'S BOX CARS BUDGETED BALANCE SHEET JUNE 30, 2020 ASSETS LIABILITIES & EQUITY Accounts Payable Notes Payable Capital Stock Retained Earnings Cash $1,450,000 $450,000 Accounts Receivable 3,900,000 Raw Material Inventory 200,000 3,500,000 Plant and Equipment 8,900.000 10,500,000 TOTAL ASSETS $14,450,000 $14,450,000 TOTAL LIAB. & SE Our controller, Tommy Swain is negotiating with potential new Wood suppliers in Kentucky. We need the Large Box Car Division's Master Budget for the fiscal year ended June 30, 2021 for our corporate strategic planning process, and we cannot wait for Tommy's return from Kentucky. We would like you to prepare the Large Box Car Division's Master Budget for the fiscal year ended June 30, 2021. The deliverables are as follows: 1. Sales budget, including a schedule of expected cash collections. 2. Production budget. 3. Direct materials budget, including a schedule of expected cash disbursements for materials. 4. Direct labor budget. 5. Manufacturing overhead budget. 6. Ending finished goods inventory budget calculating the expected value of the finished goods inventory as of June 30, 2021. * 7. Selling and administrative expense budget. 8. Cash budget. 9. Budgeted income statement for the year ended June 30, 2021. * 10. Budgeted balance sheet for June 30, 2021. All the Master Budget schedules except those marked with an asterisk for the Large Box Car 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). Tommy's Box Cars DATE: June 1, 2020 CCSU Consulting то: FROM: Mark Swain, President, Tommy's Box Cars SUBJECT: Master Budget for the fiscal year July 1, 2020 - June 30, 2021 Tommy's Box Cars During 2019-20 fiscal year, the average selling price for large box cars is expected to be $130 per car. The Large Box Car Division forecasts the following units of sales. Third Quarter Box Car UNIT Sales First 65,000 Second 70,000 Fourth 60,000 55,000 The collection pattern for Accounts Receivable is as follows: • 30 percent of all sales are collected within the quarter in which they are sold . 70 percent of all sales are collected in the following quarter. There are no bad debts/uncollectible accounts. Due to high demand last year, the Large Box Car Division expects to have zero finished box cars in inventory on July 1, 2020, the beginning of the first quarter of the new fiscal year (I.e. Beginning Finished Goods Inventory is Zero). To avoid having that problem in the coming fiscal year, the Large Box Car Division would like to have the ending inventory of Box Car at the end of each of the first three quarters equal to 30% of the budgeted sales for the next quarter. They would like to have 35,000 finished Box Cars on hand on June 30, 2021. Quarter First Second Third Fourth Ending FG inventory of Box Cars as a % of the next quarter's budgeted sales 30% 30% 30% ? Ending FG inventory of Box Cars ? ? 35,000 Each large box car requires an average of 5.0 feet of wood. The Large Box Car Division buys wood for $4.00 per foot and they expect the price to remain constant throughout the year. They expect to have 50,000 feet of wood (RAw MATERIALS) on hand as of July 1, 2019 ( 50,000 * $4.00 = $200,000 - This is beginning Direct Material Inventory), the beginning of the first quarter of the fiscal year. At the end of each of the first three quarters, the Large Box Car Division would like to have their direct materials inventory quantity to equal 25 percent of the amount required for the following quarter's planned production. On June 30, 2020, the end of the fiscal year, Large Box Car Division would like to have 60,000 feet of wood on hand (This is ending Direct Material Inventory). Quarter First Second Third Fourth Ending DM inventory as a % of the next quarter's production requirement Ending DM inventory in feet 25% 25% 25% ? 60,000 The Large Box Car Division buys its wood on account. It pays for 35% of its purchases of direct materials in the quarter in which they were purchased and 65% in the quarter after they were purchased. Each large box car requires 5 hours of direct labor. Employees engaged in direct labor will be paid an estimated $10.00 per labor hour. Wages and salaries are paid on the 15th and 30th of each month. Variable manufacturing overhead is estimated to be $4.50 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 $120,000 each quarter, with $40,000 out of the total amount of $120,000 representing depreclation on machinery, equipment and the factory. All other fixed manufacturing overhead expenses are paid in cash in the quarter they occur. The fixed manufacturing Tommy's Box Cars 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 $12.00 per box car sold. Fixed selling and administrative expenses are expected to total $95,000 each quarter, with $30,000 out of the total amount of $95,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, 2020 the Large Box Car Division plans to buy new machinery and equipment for $1,000,000. The new machinery and equipment will be acquired at the very end of the fiscal 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 Box Car Division expects to pay 40% down in cash and finance the remaining 60% of the equipment cost with a note payable from a local bank with whom they do business with. No interest payable will accrue on the equipment note payable until after (33) June 30, 2020. The Division must maintain a minimum cash balance of $100,000. If after accounting for cash receipts and disbursements (including dividends) in the cash budget, the budgeted cash available cash falls below $100,000 in any quarter, the Division will need to borrow cash. They have arranged a line of credit allowing it to borrow in $10,000 increments (i.e. they can borrow $10,000 or $20,000 etc. but not an odd amount). Assume borrowing will take place at the beginning of any quarter in which the available cash would otherwise be below $100,000 so that at no time during the quarter will the cash balance fall below $100,000 (after payment of interest). If there is extra cash at the end of the quarter and there is borrowing outstanding, the division should pay down principal (also in increments of $10,000). The bank charges the Division interest at the rate of 3% per quarter. Interest accrued in the quarter will be paid the first day of the next quarter (e.g. Q1's interest is not paid in cash until Q2 and Q2's Interest will be paid in Q3). As a fully owned subsidiary, the Large Box Car Division does not pay income taxes. All income taxes are charged to Tommy's Box Car's, the parent company. Large Box Car Division will pay dividends of $50,000 each quarter to its corporate parent, Tommy's Box Car's. The dividends must be paid, even if the Large Box Car Division has to borrow on its line of credit to make the payment The budgeted balance sheet for the Large Box Car Division on June 30, 2020 (which is the same as the budgeted balance sheet at the begining of business July 1, 2020) is presented below. Tommy's Box Cars owns 100% of the Capital Stock of the Large Box Car Division. LARGE BOX CAR DIVISION – TOMMY'S BOX CARS BUDGETED BALANCE SHEET JUNE 30, 2020 ASSETS LIABILITIES & EQUITY Accounts Payable Notes Payable Capital Stock Retained Earnings Cash $1,450,000 $450,000 Accounts Receivable 3,900,000 Raw Material Inventory 200,000 3,500,000 Plant and Equipment 8,900.000 10,500,000 TOTAL ASSETS $14,450,000 $14,450,000 TOTAL LIAB. & SE
Expert Answer:
Answer rating: 100% (QA)
Sales Budget Uniyt sales Unit sale price Budgeted sale value Q1 Q2 Q3 Q4 Year 65000 70000 60000 6500... View the full answer
Related Book For
Essentials of Accounting for Governmental and Not-for-Profit Organizations
ISBN: 978-0073527055
10th Edition
Authors: Paul A. Copley
Posted Date:
Students also viewed these accounting questions
-
Consider an Open Economy with Fixed Exchange Rate. What is the accompanying movement in IS/LM when AS shifts. Assume that AD is downward sloping and does not shift. a. IS shift b. LM shift c. Both a....
-
The City of South Dundee budget for the fiscal year ended June 30, 2012, included an appropriation for the police department in the amount of $16,000,000. During the month of July 2011, the following...
-
The City of South Dundee budget for the fiscal year ended June 30, 2017, included an appropriation for the police department in the amount of $8,700,000. During the month of July 2016, the following...
-
What effect does a weakening in U.S dollar have on Net Income for subsidiaries of U.S companies?
-
Form a small group of five or six people to discuss the following statement: "Correct identification and appropriate definition of the marketing research problem are more crucial to the success of a...
-
Describe the basic function, structure, and powers of the executive branch of government?
-
The following data pertain to water pressure at various depths below sea level: (a) Fit an exponential curve. (b) Use the result obtained in part (a) to estimate the mean pressure at a depth of...
-
The port of Lajitas has three loading docks. The distance (in meters) between the loading docks is given in the table below: Three tankers currently at sea are coming into Lajitas. It is necessary to...
-
How to draft a Job Analysis for an employee's jobs in human resources. Explain the process you used and why. Explain the outcomes of the job analysis and how these outcomes would be useful in the...
-
On January 1, 20X1, partners Art, Bru, and Chou, who share profits and losses in the ratio of 5:3:2, respectively, decide to liquidate their partnership. The partnership trial balance at this date...
-
(a) In the Seeheim model: Treating the Application Interface model and Application together, there are three main layers: (i) presentation/lexical (ii) dialogue/syntactic (iii) application/semantic...
-
How is the auditor of a government company appointed?
-
Distinguish between internal audit and statutory audit.
-
Describe the manner in which the CAG controls the audit of government companies.
-
Describe briefly the common types of computer-assisted audit techniques?
-
Define Auditing. Discuss the scope and procedure of Audit.
-
-kx 2ky -2ky (a) show that f(x,y) = (Ae** + Be***) (Ce + Dezky) Is a solution of the wave equation 227 -- 4 2x = (b) If z= f(xy), where x = rcose y=rsine and f is contineous second partial derivative...
-
Portal Manufacturing has total fixed costs of $520,000. A unit of product sells for $15 and variable costs per unit are $11. a). Prepare a contribution margin income statement showing predicted net...
-
The state government established a capital project fund in 2011 to build new highways. The fund is supported by a 5 percent tax on diesel fuel sales in the state. The tax is collected by private gas...
-
What are the required financial statements of the U.S. government?
-
During 2011, the following transactions were recorded by the Baton Rouge Community Hospital, a private-sector, not-for-profit institution. 1. Gross charges for patient services, all charged to...
-
If so, is it similar to one of the three formats illustrated in this chapter? If not, how is it different?
-
Do you know about the chart of accounts in your organization as it pertains to information you receive?
-
If so, did you receive the information in a formal seminar or in an informal manner, oneon-one with another individual? Do you think this was the best way? Why?
Study smarter with the SolutionInn App