Question

( 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:

Trolley Toy Company Balance Sheet December 31, 2018 Assets Current Assets: Cash 58,000 Accounts Receivable 22,000 Raw Materia

(Unless otherwise noted, assume all of the following events occurred during 2018 and that any balances given are stated as of

1. Prepare Trolleys operating budget and cash budget for 2019 by quarter. Required schedules and budgets include: sales budgTrolley Toy Company Income Statement For the Year Ended December 31, 2019 Net Sales Revenue 630,000 Cost of Goods Sold: Varia

Trolley Toy Company Sales Budget For the Year Ended December 31, 2019 First Second Third Fourth Quarter Quarter Quarter Quart

Fixed Variable Total $ 84,240 $ Static budget 38,340 $ 122,580 Flexible budget 93,940 38,340 132,280Standard Cost Information Quantity Cost Direct materials 2.00 per pound 3 pounds per set 12.00 per hour 0.30 hours per set Di

Actual Cost Information 20,700 pounds $ Direct materials 2.50 per pound) 51,750 $ 12.40 per hour) Direct labor 2,060 hours 25Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total 126,000 139,500 153,000 $ 166,50

Cash Payments First Second Third Fourth Quarter Quarter Quarter Quarter Total 9,750 S 10,650| S 10,686 $ 11,514 S Total direc

Manufacturing Overhead: 6,336 6,876 Variable manufacturing overhead 6,552 5,796 25,560 2,585 Utilities, insurance, property tCash Budget For the Year Ended December 31, 2019 First 4th Psl p Quarter Beginning cash balance Cash receipts Cash available

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
( please answer all the questions) The Trolley Trolley Toy Company manufactures toy building block sets...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning...

    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...

    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...

    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...

    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...

    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. ...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT