Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The records of Carillion Corporation show the following information concerning the Sub-Budgets for the coming period 2019 as follows: Sub-Budgets Q1/19 Q2/19 Q3/19 Q4/19 Sales

image text in transcribed

The records of Carillion Corporation show the following information concerning the Sub-Budgets for the coming period 2019 as follows: Sub-Budgets Q1/19 Q2/19 Q3/19 Q4/19 Sales Revenues 5,971,000 4,881,000 6,381,000 4,581,000 Sales Collection 6,270,000 5,240,000 6,870,000 5,265,000 Production 85,200 76,900 81,500 57,600 Labor Hours 145,000 167,800 158,700 157,900 Direct wages 625,000 450,000 590,000 352,000 Req. RM in Units 75,824 72,584 84,258 89,253 Purchase RM in Units 78,925 75,957 85,478 89,547 Purchase RM in Dollars 144,200 152,600 161,900 172,300 Purchase Payments 485,900 457,200 456,500 472,800 M.O.H 450,000 480,000 510,000 520,000 MKT. & ADM. 245,000 268,000 272,000 249,000 Given that: 1. Estimated beginning cash balance is $977,600. 2. Factory machines dep. per year is $80,000, sales equipment dep. per month is $8,000, factory- building dep. per quarter is $9,000, display equipment dep. per half year is $30,000, and administrative dep. each 6-month is $ 25,000. 3. Old machines of $550,000 will be sold, 40% will be collected in Q3/19, 30% in the next quarter, and the rest in the quarter after. 4. A production line costing $500,000 will be added, 35% of the cost will be paid in Q2/19, 40% next quarter, and the rest in the quarter after. 5. Used vehicles will be sold for $360,000; the amount will be collected over 4 equal installments starting Q1/19. 6. A loan installments of $120,000 will be paid in Q2/19 and of $126,000 in Q4/19. 7. An extension of the warehouse costing $350,000 will be made, 60% of the cost will be paid in Q2/19 and the rest in Q4/19. 8. A land lot of $600,000 will be sold, 40% will be collected inQ1/19, and the rest in the next quarter. 9. Used fixtures and fittings will be sold for $800,000, $220,000 will be collected in Q1/19, $350,000 will be collected in Q2/19, and the rest in the next quarter. 10. A cash distribution of 1% of the total sales revenues will be paid to employees in each quarter. Required: Prepare the cash budget for the coming year 2019

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions