Question
The KGV Blood Bank, a private charity partly supported by government grants, is located onthe Caribbean island of St. Lucia. The blood bank has just
The KGV Blood Bank, a private charity partly supported by government grants, is located onthe Caribbean island of St. Lucia. The blood bank has just finished its operations for September,which was a particularly busy month due to a powerful hurricane that hit neighboring islands causingmany injuries. The hurricane largely bypassed St. Lucia, but residents of St. Lucia willingly donated their blood to help people on other islands. As a consequence, the blood bank collectedand processed over 20% more blood than had been originally for Continued support from the government depends on the blood banks ability to demonstrate controlover its costs.the blood bank appears on the following page. (The currency on St. Lucia is the East Caribbean dollar.) planned for the month.A report prepared by a government official comparing actual costs to budgeted costs
please answer the second part of the question and A report comparing actual costs to budgeted costs ?
A B C D E F G H JK L M N O P The KGV Blood Bank, a private charity partly supported by government grants, is located on the Caribbean island of St. Lucia The blood bank has just finished its operations for September, which was a particularly busy month due to a powerful hurricane that hit neighboring islands causing many injuries. The hurricane largely bypassed St. Lucia, but residents of St. Lucia willingly donated their blood to help people on other islands. As a consequence, the blood bank collected and processed over 20% more blood than had been originally planned for the month. Processing the blood includes lab tests to ensure there are no blood-transmittable diseases. A report prepared by a government official comparing actual costs to budgeted costs for the blood bank appears below. Continued support from the government depends on the blood bank's ability to demonstrate control over its costs and safety of the blood supply. Complete a FLEXIBLE BUDGET to reflect the actual litres of blood collected and answer the questions on the next tab. KGV Blood Bank September 2019 KGV Blood Bank September 2019 Static Budget 600 Actual 720 Variance 120 Favourable! Unfavourable Litres of Blood collected Flexible Budget Actual Costs 720 Variance Variable Costs $ Price Per Unit 12.00 9.99 2.17 = Lab Tests Refreshments 7,200.00 5,995.00 1,300.00 $ 9,400.00 6,200.00 1,450.00 Variable Costs $2,200.00 Medical costs 205.00 Lab tests 150.00 Refreshments P 8,640.00 7,194.00 ,560.00 $ 8,560.00 6,050.00 1,520.00 $ (80.00) (1,144.00) (40.00) favourable favourable unfavourable 1 Fixed Costs Fixed costs Rent Utlities 850.00 450.00 850.00 450.00 Rent Utilities 850.00 450.00 850.00 450.00 neither neither - Total Expense $ 15,795.00 ######## $2,555.00 Total Expense 18,694.00 $(1,264.00) favorable * Cut E Autosum A B X -15 ACCT8090 F19 Budget Quiz - Section 2 final - Microsoft Excel (Product Activation Failed) - 2 X File Home Insert Page Layout Formulas Data Review View - x AutoSum - A Arial - 11 AA = = = Wrap Text General E Copy Fill 2 m Paste BI U- - A E Format Painter Merge & Center % 48,00 Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing AB2 for The KGV Blood Bank, a private charity partly supported by government grants, is located onthe Caribbean island of St. Lucia. The blood bank has just finished its operations for X Y Z AA | AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR The KGV Blood Bank, a private charity partly supported by government grants, is located onthe Caribbean island of St Lucia. The blood bank has just finished its operations for September, which was a particularly busy month due to a powerful hurricane that hit neighboring islands causingmany injuries. The hurricane largely bypassed St. Lucia, but residents of St. Lucia willingly donated their blood to help people on other islands. As a consequence, the blood bank collectedand processed over 20% more blood than had been originally for Continued support from the government depends on the blood bank's ability to demonstrate controlover its costs. the blood bank appears on the following page (The currency on St. Lucia is the East Caribbean dollar.) planned for the month. A report prepared by a government official comparing actual costs to budgeted costs Cover Page Flex Budget Questions Ready 1 200 100% 0 A. ENG 22:17 + O R e N @ X OP D A B C D E F G H JK L M N O P The KGV Blood Bank, a private charity partly supported by government grants, is located on the Caribbean island of St. Lucia The blood bank has just finished its operations for September, which was a particularly busy month due to a powerful hurricane that hit neighboring islands causing many injuries. The hurricane largely bypassed St. Lucia, but residents of St. Lucia willingly donated their blood to help people on other islands. As a consequence, the blood bank collected and processed over 20% more blood than had been originally planned for the month. Processing the blood includes lab tests to ensure there are no blood-transmittable diseases. A report prepared by a government official comparing actual costs to budgeted costs for the blood bank appears below. Continued support from the government depends on the blood bank's ability to demonstrate control over its costs and safety of the blood supply. Complete a FLEXIBLE BUDGET to reflect the actual litres of blood collected and answer the questions on the next tab. KGV Blood Bank September 2019 KGV Blood Bank September 2019 Static Budget 600 Actual 720 Variance 120 Favourable! Unfavourable Litres of Blood collected Flexible Budget Actual Costs 720 Variance Variable Costs $ Price Per Unit 12.00 9.99 2.17 = Lab Tests Refreshments 7,200.00 5,995.00 1,300.00 $ 9,400.00 6,200.00 1,450.00 Variable Costs $2,200.00 Medical costs 205.00 Lab tests 150.00 Refreshments P 8,640.00 7,194.00 ,560.00 $ 8,560.00 6,050.00 1,520.00 $ (80.00) (1,144.00) (40.00) favourable favourable unfavourable 1 Fixed Costs Fixed costs Rent Utlities 850.00 450.00 850.00 450.00 Rent Utilities 850.00 450.00 850.00 450.00 neither neither - Total Expense $ 15,795.00 ######## $2,555.00 Total Expense 18,694.00 $(1,264.00) favorable * Cut E Autosum A B X -15 ACCT8090 F19 Budget Quiz - Section 2 final - Microsoft Excel (Product Activation Failed) - 2 X File Home Insert Page Layout Formulas Data Review View - x AutoSum - A Arial - 11 AA = = = Wrap Text General E Copy Fill 2 m Paste BI U- - A E Format Painter Merge & Center % 48,00 Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing AB2 for The KGV Blood Bank, a private charity partly supported by government grants, is located onthe Caribbean island of St. Lucia. The blood bank has just finished its operations for X Y Z AA | AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR The KGV Blood Bank, a private charity partly supported by government grants, is located onthe Caribbean island of St Lucia. The blood bank has just finished its operations for September, which was a particularly busy month due to a powerful hurricane that hit neighboring islands causingmany injuries. The hurricane largely bypassed St. Lucia, but residents of St. Lucia willingly donated their blood to help people on other islands. As a consequence, the blood bank collectedand processed over 20% more blood than had been originally for Continued support from the government depends on the blood bank's ability to demonstrate controlover its costs. the blood bank appears on the following page (The currency on St. Lucia is the East Caribbean dollar.) planned for the month. A report prepared by a government official comparing actual costs to budgeted costs Cover Page Flex Budget Questions Ready 1 200 100% 0 A. ENG 22:17 + O R e N @ X OP DStep 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