Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here is the next quiz ................................ please and thank you Budgeted Sales February March April May June 300000 330000 370000 570000 180000 Requirment 1 February
Here is the next quiz ................................ please and thank you
Budgeted Sales February March April May June 300000 330000 370000 570000 180000 Requirment 1 February sales March sales April sales May sales June Sales Total Cash Collection April May June 30000 214500 33000 75000 240500 37000 142500 370500 45000 319500 416000 452500 Requirment 2 May Sales June Sales Total Account Receivables 199500 135000 334500 100 Q1 Beginning Cash Balance Total Cash Recipts Total Cash Avialable Less Total Cash Disbursment Excess(Deficiency) of Cash Avialable over Disbursments Financing Borrwings Repayment Interest Total Financing Q2 42000 290000 332000 337000 -5000 15000 0 0 10000 Q3 Q4 10000 127550 150550 440000 320000 340000 450000 447550 490550 307000 297000 317000 143000 150550 173550 0 -15000 -450 127550 0 0 0 150550 0 0 0 173550 Year 42000 1390000 1432000 1258000 174000 15000 -15000 -450 173550 Budgeted Sales February March April May June 300000 330000 370000 570000 180000 Requirment 1 February sales March sales April sales May sales June Sales Total Cash Collection April May June 30000 214500 33000 75000 240500 37000 142500 370500 45000 319500 416000 452500 Requirment 2 May Sales June Sales Total Account Receivables 199500 135000 334500 100 Q1 Beginning Cash Balance Total Cash Recipts Total Cash Avialable Less Total Cash Disbursment Excess(Deficiency) of Cash Avialable over Disbursments Financing Borrwings Repayment Interest Total Financing Q2 42000 290000 332000 337000 -5000 15000 0 0 10000 Q3 Q4 10000 127550 150550 440000 320000 340000 450000 447550 490550 307000 297000 317000 143000 150550 173550 0 -15000 -450 127550 0 0 0 150550 0 0 0 173550 Year 42000 1390000 1432000 1258000 174000 15000 -15000 -450 173550 Production Budget July Budgeted Unit sales Ending Finished goods Total Needs Less Beginning Finished goods Required Production in Units 45000 16500 61500 -15250 46250 August September 50000 60000 19000 14000 69000 74000 -16500 -19000 52500 55000 Direct MateriaL BUDGET July August September Units of raw material nneded to meet produtions 138750 157500 165000 Add: Desired units of ending raw materials invent 78750 82500 56250 Total units of raw materials needed 217500 240000 221250 Less: Units of beginning raw materials inventory -64000 -78750 -82500 Units of raw materials to be purchased 153500 161250 138750 Budgeted Sales February March April May June 300000 330000 370000 570000 180000 Requirment 1 February sales March sales April sales May sales June Sales Total Cash Collection April May June 30000 214500 33000 75000 240500 37000 142500 370500 45000 319500 416000 452500 Requirment 2 May Sales June Sales Total Account Receivables 199500 135000 334500 100 Q1 Beginning Cash Balance Total Cash Recipts Total Cash Avialable Less Total Cash Disbursment Excess(Deficiency) of Cash Avialable over Disbursments Financing Borrwings Repayment Interest Total Financing Q2 42000 290000 332000 337000 -5000 15000 0 0 10000 Q3 Q4 10000 127550 150550 440000 320000 340000 450000 447550 490550 307000 297000 317000 143000 150550 173550 0 -15000 -450 127550 0 0 0 150550 0 0 0 173550 Year 42000 1390000 1432000 1258000 174000 15000 -15000 -450 173550 Budgeted Unit sales Ending Finished goods Total Needs Less Beginning Finished goods Required Production in Units Production Budget July August September October 45000 50000 60000 40000 16500 19000 14000 11500 61500 69000 74000 51500 -15250 -16500 -19000 -14000 46250 52500 55000 37500 Direct MateriaL BUDGET July August September October Units of raw material nneded to meet produtions 138750 157500 165000 112500 Add: Desired units of ending raw materials invent 78750 82500 56250 41250 Total units of raw materials needed 217500 240000 221250 153750 Less: Units of beginning raw materials inventory -64000 -78750 -82500 -56250 Units of raw materials to be purchased 153500 161250 138750 97500 Vulcan FlexibleFlyovers Budget Performance For the MonthReport Ended July 31 Revenue Expenses: Wages and salaries Fuel Airport fees Aircraft depreciation Office expenses Total expense Net operating income Budgeted Sales February March April May June 300000 330000 370000 570000 180000 Requirment 1 February sales March sales April sales May sales June Sales Total Cash Collection April May June 30000 214500 33000 75000 240500 37000 142500 370500 45000 319500 416000 452500 Requirment 2 May Sales June Sales Total Account Receivables 199500 135000 334500 100 Q1 Beginning Cash Balance Total Cash Recipts Total Cash Avialable Less Total Cash Disbursment Excess(Deficiency) of Cash Avialable over Disbursments Financing Borrwings Repayment Interest Total Financing Q2 42000 290000 332000 337000 -5000 15000 0 0 10000 Q3 Q4 10000 127550 150550 440000 320000 340000 450000 447550 490550 307000 297000 317000 143000 150550 173550 0 -15000 -450 127550 0 0 0 150550 0 0 0 173550 Year 42000 1390000 1432000 1258000 174000 15000 -15000 -450 173550 Budgeted Unit sales Ending Finished goods Total Needs Less Beginning Finished goods Required Production in Units Production Budget July August September October 45000 50000 60000 40000 16500 19000 14000 11500 61500 69000 74000 51500 -15250 -16500 -19000 -14000 46250 52500 55000 37500 Direct MateriaL BUDGET July August September October Units of raw material nneded to meet produtions 138750 157500 165000 112500 Add: Desired units of ending raw materials invent 78750 82500 56250 41250 Total units of raw materials needed 217500 240000 221250 153750 Less: Units of beginning raw materials inventory -64000 -78750 -82500 -56250 Units of raw materials to be purchased 153500 161250 138750 97500 Vulcan Flyovers Flexible Budget Performance Report For the Month Ended July 31 Revenue and Spending Activity Variances Variances Revenue Expenses: Wages and salaries Fuel Airport fees Aircraft depreciation Office expenses Total expense Net operating income 710 F 3780 U 178 U 64 U 66 U 20 U 2U 330 U 380 F 38 F 166 U 105 F 0 None 168 U 191 U 3971 UStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started