3. You have the following information about a restaurant: Budgeted Cash Revenue $30,300 29,500 27,900 25,100...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. You have the following information about a restaurant: Budgeted Cash Revenue $30,300 29,500 27,900 25,100 32,400 August September October November December Collections on credit revenue average 90% in the month following the sales and the remaining 10% in the month following. Cost of sales (purchases) averages 38% of total sales revenue. Forty percent of cost of sales is on a cash basis, and 60% is paid in the month following purchase. Payroll costs (which are paid on a cash basis) are forecast to be $13,100 for October; $12,700 for November; and $12,200 for December. Other budgeted expenses according to the forecast income statements follow: Rent expense Insurance Expense Utilities expense Other operating costs Depreciation (equipment) Interest expense October $2,500 300 500 1,100 4,600 400 Budgeted Credit Revenue $16,000 14,000 13,000 12,000 15,800 November $2,500 300 450 900 4,600 400 December $2,500 300 550 1,300 4,600 400 Note that the rent, utilities, other operating costs, and interest are paid in cash each month as the expense is incurred. The insurance expense is paid in January each year in advance for the whole year ($3,600). The restaurant financed its equipment and makes monthly payments on the balance owing (principal amount) of $1,000. In December, the restaurant plans to sell off some old equipment and estimates it will receive $1,500 from the sale. At the same time, it must spend $5,400 on new equipment. If there is sufficient cash on hand, the owner plans to pay a bonus to the staff. This bonus will amount to $3,600 and will be paid in December. Prepare the restaurant's cash budget for each of the three months: October, November, and December. The beginning cash balance October 1 is $2,410. 3. You have the following information about a restaurant: Budgeted Cash Revenue $30,300 29,500 27,900 25,100 32,400 August September October November December Collections on credit revenue average 90% in the month following the sales and the remaining 10% in the month following. Cost of sales (purchases) averages 38% of total sales revenue. Forty percent of cost of sales is on a cash basis, and 60% is paid in the month following purchase. Payroll costs (which are paid on a cash basis) are forecast to be $13,100 for October; $12,700 for November; and $12,200 for December. Other budgeted expenses according to the forecast income statements follow: Rent expense Insurance Expense Utilities expense Other operating costs Depreciation (equipment) Interest expense October $2,500 300 500 1,100 4,600 400 Budgeted Credit Revenue $16,000 14,000 13,000 12,000 15,800 November $2,500 300 450 900 4,600 400 December $2,500 300 550 1,300 4,600 400 Note that the rent, utilities, other operating costs, and interest are paid in cash each month as the expense is incurred. The insurance expense is paid in January each year in advance for the whole year ($3,600). The restaurant financed its equipment and makes monthly payments on the balance owing (principal amount) of $1,000. In December, the restaurant plans to sell off some old equipment and estimates it will receive $1,500 from the sale. At the same time, it must spend $5,400 on new equipment. If there is sufficient cash on hand, the owner plans to pay a bonus to the staff. This bonus will amount to $3,600 and will be paid in December. Prepare the restaurant's cash budget for each of the three months: October, November, and December. The beginning cash balance October 1 is $2,410.
Expert Answer:
Answer rating: 100% (QA)
To prepare the restaurants cash budget for each of the three months October November and December we need to consider the cash inflows and outflows du... View the full answer
Related Book For
Management Accounting
ISBN: 9780077185534
6th Edition
Authors: Will Seal, Carsten Rohde, Ray Garrison, Eric Noreen
Posted Date:
Students also viewed these finance questions
-
What is the function of anti-pumping in circuit breaker?
-
After graduating from Eastern University in Campus Town, USA with a degree in business, Michael Woods realized that he wanted to remain in Campus Town. After a number of unsuccessful attempts at...
-
Integer sort. Write a linear-time filter that reads from standard input a sequence of integers that are between 0 and 99 and prints to standard output the same integers in sorted order. For example,...
-
Normal body temperature for humans is 98.6 F. What is the corresponding temperature in (a) Degrees Celsius (b) Kelvins?
-
Consider each of the following molecules in turn: (a) Dimethyl ether, (CH3)2O; (b) Trimethylamine, (CH3)3N; (c) Trimethylboron, (CH3)3B; and (d) Dimethylberyllium, (CH3)2Be. Describe the...
-
Consider the National Football League data in Table B.1. Restricting your attention to regressors \(x_{1}\) (rushing yards), \(x_{2}\) (passing yards), \(x_{4}\) (field goal percentage), \(x_{7}\)...
-
Salem Inc, reported the following data: Net income ............$168,750 Depreciation expense .......... 18,750 Gain on disposal of equipment .... 15,375 Decrease in accounts receivable ..... 10,500...
-
Daffy Corporation has two processing departments-Mixing and Cooking. Daffy uses the FIFO method. The following information relates to the Mixing Department: Percentage Complete Mixing Department...
-
Prepare journal entries for the above transactions. Aylmer Industries Inc. (Aylmer) has been in business since 2018. Aylmer has two main business segments. This first segment is the construction of...
-
The storage of radioactive waste is an important problem in the nuclear industry. One problem that scientists must take into account is volumetric expansion. Consider a 50.0 gallon cylindrical metal...
-
For the shapes below, what is the moment of force BC about axis OA? 0.925 m G 0.35 m 0.5 m B 0.875 m 0.5 m O (r(OD)XF(BH)).landa(OH) O landa(OD).(r(OB)XF(BH)) O F(OA).(landa(AD)Xr(AB)) O landa (OA)....
-
Ceres is a dwarf planet located in the asteroid belt between the orbits of Mars and Jupiter. The radius of Ceres is 4.76x105 m. Suppose an astronaut stands on the surface of Ceres and drops a 0.85 kg...
-
A satellite in orbit above Earth's equator is traveling at an orbital speed of 7.00 km/s. Determine the altitude of the satellite. (3T) the satelit G = 6.67x10-11 mkg-5-2 ME = 5.98x1024 kg TE =...
-
A minivan and a car undergo a crash test. The mass of the minivan is 9.0 x 10 kg, and the mass of the car is 660 kg. The minivan was moving north, and the car was moving east. After the collision,...
-
Records for the Bass Corporation's defined-benefit pension plan show a net unrecognized loss at De- cember 31, 2013, of $30,000, after recording the pension expense for 2013. The average expected...
-
Chao, Louis, and Mari, unrelated individuals, own all of the shares of Cerise Corporation. All three shareholders have been active in the management of Cerise since its inception. In the current...
-
Refer to the data in E12-3. Assume that instead of producing 4,000 units during the month, the company produced only 3,000 units, using 14,750 kilos of material in the production process. (The rest...
-
Thompson and White Ltd is a snack and beverage manufacturing company. On 1 January of next year, the company is planning to launch flavoured potato crisps Delish. The management has decided that the...
-
Why are product costs sometimes called inventoriable costs? Describe the flow of such costs in a manufacturing company from the point of incurrence until they finally become expenses in the statement...
-
Assume you want to use random tests on an FIR filter program. How would you know when the program under test is executing correctly?
-
Three devices are attached to a microprocessor: Device 1 has highest priority and device 3 has lowest priority. Each devices interrupt handler takes 5 time units to execute. Show what interrupt...
-
Provide examples of how each of the following can occur in a typical program: a. compulsory miss b. capacity miss c. conflict miss
Study smarter with the SolutionInn App