( please answer all the questions) The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning for 2019 2019 by developing a master budget by quarters. Trolley Trolley's balance sheet for December December 31 31, 2018 2018, follows:
Cash Budget | ||||
First Quarter | Second Quarter | Third Quarter | Fourth Quarter | |
Beginning Cash Balance | $ 58,000.00 | $ 55,904.00 | $ 1,44,548.00 | $ 2,45,651.00 |
Cash Receipts | $ 95,080.00 | $ 1,33,830.00 | $ 1,47,330.00 | $ 1,60,830.00 |
Cash available | $ 1,53,080.00 | $ 1,89,734.00 | $ 2,91,878.00 | $ 4,06,481.00 |
Cash Payments | ||||
Capital Expenditures | $ 45,000.00 | |||
Purchases of Direct Materials | $ 17,617.00 | $ 9,844.00 | $ 10,560.00 | $ 11,428.00 |
Direct Labor | $ 6,552.00 | $ 5,796.00 | $ 6,336.00 | $ 6,876.00 |
Manufacturing Overhead | $ 9,137.00 | $ 8,381.00 | $ 8,921.00 | $ 9,461.00 |
Selling and Administrative Expenses | $ 16,370.00 | $ 16,640.00 | $ 16,910.00 | $ 17,180.00 |
Income Taxes | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 |
Interest Expense | $ 25.00 | |||
Total Cash Payments | $ 98,176.00 | $ 44,186.00 | $ 46,227.00 | $ 48,445.00 |
Ending Cash Balance before financing | $ 54,904.00 | $ 1,45,548.00 | $ 2,45,651.00 | $ 3,58,036.00 |
Projected cash excess (deficiency) | $ 55,000.00 | $ 55,000.00 | $ 55,000.00 | $ 55,000.00 |
Finanicng | $ -96.00 | $ 90,548.00 | $ 1,90,651.00 | $ 3,03,036.00 |
Borrowing | $ 1,000.00 | $ - | $ - | $ - |
Principal Repayments | $ - | $ 1,000.00 | $ - | $ - |
Ending Cash Balance after financing | $ 55,904.00 | $ 1,44,548.00 | $ 2,45,651.00 | $ 3,58,036.00 |
( please answer all the questions) The Trolley Trolley Toy Company manufactures toy building block sets...
The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning for 2019 2019 by developing a master budget by quarters. Trolley Trolley's balance sheet for December December 31 31, 2018 2018, follows: Trolley Toy Company Balance Sheet December 31, 2018 Assets Current Assets: Cash 58,000 Accounts Receivable 22,000 Raw Materials Inventory 1,200 5,400 Finished Goods Inventory Total Current Assets 86,600 Property, Plant, and Equipment Equipment 142,000 (47,000) 95,000 Less: Accumulated Depreciation 181,600 Total Assets...
Requirement 1. Prepare Cooke Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018 Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash Receipts from Customers First Quarter 2018 i Data Table Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2017 1st Qtr-Sales Total cash receipts from customers Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing...
haney company has provided the following budget information for the first quarter of 2018: Haney Company has provided the following budget information for the first quarter of 2018 (Click the loon to view the budget information.) Additional data related to the first quarter of 2018 for Haney Company (Click the icon to view the data.) Read the requirements Requirement 1. Prepare Haney Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018...
The Gridley Tire Company manufactures racing tires for bicycles. Gridley sells tires for $75 each Gridley is planning for the next year by developing a master budget by quarters. Gridley's balance sheet for December 31, 2018, follows (Click the icon to view the balance sheet) Other data for Gridley Tire Company i Clck he icon to view the other data) Read the repuiremens. Revew the sales budget you prepared above Cash Receipts from Customers Third First Second Fourth Quarter Quarter...
The Gerard Tire Company manufactures racing tires for bicycles. Gerard sells tires for $90 each. Gerard is planning for the next year by developing a master budget by quarters. Gerard’s balance sheet for December 31, 2018, follows: Other data for Gerard Tire Company: Budgeted sales are 1,500 tires for the first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account. Finished...
The Gerard Tire Company manufactures racing tires for bicycles. Gerard sells tires for $90 each. Gerard is planning for the next year by developing a master budget by quarters. Gerard’s balance sheet for December 31, 2018, follows: Other data for Gerard Tire Company: Budgeted sales are 1,500 tires for the first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account. Finished...
Other data for Giseppe Tire Company: (Click the icon to view the other data.) The Giseppe Tire Company manufactures racing tires for bicycles. Giseppe sells tires for $80 each. Giseppe is planning for the next year by developing a master budget by quarters. Giseppe's balance sheet for December 31, 2018, follows: (Click the icon to view the balance sheet.) Read the requirements. Requirement 1. Prepare Giseppe's operating budget and cash budget for 2019 by quarter. Required schedules and budgets include:...
ang Company has provided the following budget information for the first quarter of 2018: Click the icon to view the budget information.) Additional data related to the first quarter of 2018 for Vang Company (Click the icon to view the data.) Read Х More Info Requirement 1. Prepare Vang Company's schedule of cash receipts from customers and schedule of cash payments for th Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash...
Homework: P22-41 Score: 45.52 of 100 pts 1 of 1 (1 complete) P22-41A (similar to) The Grady Tire Company manufactures racing tires for bicycles. Grady sells tires for $70 each. Grady is Other data for Grady Tire Compar planning for the next year by developing a master budget by quarters. Grady's balance sheet for (Click the icon to view the oth December 31, 2018, follows: (Click the icon to view the balance sheet.) Read the requirements Cash Receipts from Customers...
The Giseppe Tire Company manufactures racing tires for bicycles. sells tires for $80 each. Giseppe is planning for the next year by developing a master budget by quarters. balance sheet for follows Requirements: 1.Prepare Giseppe'operating budget and cash budget for 2019 by quarter. Required schedules and budgets include: sales budget, production budget, direct materials budget, direct labor budget, manufacturing overhead budget, cost of goods sold budget, selling and administrative expense budget, schedule of cash receipts, schedule of cash payments, and...