Solved

Giant Koala Stores Inc A)$761 Million
B)$8

Question 5

Multiple Choice

Giant Koala Stores Inc. has forecasted sales for July through October in the top row of the table. Forecasted collections from cash and credit sales as well as forecasted payments to suppliers are also shown in the table. Wages, general & administrative expenses are 28% of the current month's sales. Giant Koala starts August with a cash balance of $7.61M. What is the cash balance at the end of September? Sales Forecast and Cash Budget
Giant Koala Stores Inc. ($000,000)
 July  August  September  October  Sales Forecast $27.000$27.000$33.000$32.500 Cash Sales 15.30022.95028.05027.625 Collections from last  Month 4.0504.0504.950 Total Cash Inflows 27.00032.10032.575 Total Payments to  Suppliers  Wages, General & 17.94021.418 Admin Expenses 7.5607.5609.240 Total Disbursements 25.50030.658 Net Cash Flows  Beginning cash  balance $7.610 Plus: Net Cash Flows  Ending cash Balance \begin{array}{|l|c|c|c|c|} \hline& \text { July } & \text { August } & \text { September } & \text { October } \\\hline \text { Sales Forecast } & \$ 27.000 & \$ 27.000 & \$ 33.000 & \$ 32.500 \\\hline \text { Cash Sales } & 15.300 & 22.950 & 28.050 & 27.625 \\\hline \text { Collections from last } & & & & \\\text { Month } & & 4.050 & 4.050 & 4.950 \\\hline \text { Total Cash Inflows } & & 27.000 & 32.100 & 32.575 \\\hline \begin{array}{l}\text { Total Payments to } \\\text { Suppliers }\end{array} & & & & \\\hline \text { Wages, General \& } & & 17.940 & 21.418 & \\\text { Admin Expenses } & 7.560 & 7.560 & 9.240 & \\\hline \text { Total Disbursements } & & 25.500 & 30.658 & \\\hline \text { Net Cash Flows } & & & & \\\hline \text { Beginning cash } & & & & \\\text { balance } & & \$ 7.610 & & \\\hline \text { Plus: Net Cash Flows } & & & & \\\hline \text { Ending cash Balance } & & & &\\\hline\end{array}


A) $7.61 million
B) $8.61 million
C) $9.11 million
D) $10.55 million
E) $11.62 million

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents