Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

8. BONUS: Sithabiso's Wraps is an allorganic restaurant located near State University. It is managed by Eunice Ndlovu, and Eunice is preparing her firstquarter cash

8. BONUS: Sithabiso's Wraps is an allorganic restaurant located near State University. It is managed by Eunice Ndlovu, and Eunice is preparing her firstquarter cash budget for this year. It is important to her because of the variation in volume and cash available caused by the return of the university students. Eunice has budgeted her revenues, cost of sales, and operating expenses based on her forecasts for January, February, and March. From her hospitality management classes, Eunice recalls that her ending cash balance for one month is the beginning cash balance of the next month, and she has compiled the following information and assumptions about her operation. Percent of revenue expected to be collected in the month it was generated (current month) 80%Percent of revenue expected to be collected in the month after it was generated based on AR aging 20%Accounts receivable to be collected in January from December AR $30,000Percent of cost of sales to be paid in the month they were incurred (current month) 60%Percent of cost of sales to be paid one month after they were incurred (as AP) 40%Amount to be paid in January from AP for cost of sales incurred in December $17,000Percent of operating expenses to be paid in the month they were incurred (current month) 70%Percent of operating expenses to be paid one month after they were incurred (from AP) 30%Amount to be paid in January (from AP) for operating expenses incurred in December $21,000Percent of nonoperating expenses to be paid in the month they were incurred (current month) 100%Monthly rent expense $4,000First of each quarter insurance premium $6,000Beginning cash balance on January 1 $5,000Ending cash balance for one month is beginning cash balance of the next month Minimum required cash balance (for emergencies) $5,000Shortterm loan denominations $5,000Shortterm loan interest rate 10%Help Eunice complete her cash budget and then answer the questions that follow. Sithabiso's Wraps Cash Budget for the First Quarter of This YearGIVEN DATA January February MarchRevenues $60,000 $132,000 $76,000Cost of Sales $21,000 $46,200 $33,600Operating Expenses $28,000 $36,000 $32,000NonOperating Expenses Rent Expense $4,000 $4,000 $4,000Insurance Premiums $6,000 Current Month Second Month Schedule of Receipts (AR) 80% 20% AR from December (Received in January) $30,000 Schedule of Payments (AP) Cost of Sales 60% 40% Operating Expenses 70% 30% NonOperating Expenses 100% Cost of Sales from December (Paid in January) Operating Expenses from December (Paid in January) CASH BUDGET January February MarchReceipts Food Revenues Current Month 80% Second Month Disbursements Cost of Sales Current Month Second Month Operating Expenses Current Month Second Month NonOperating Expenses 100% Beginning Cash Balance Cash Receipts Subtotal Cash Disbursements Subtotal ShortTerm Loans Ending Cash Balance Will Eunice have to borrow any shortterm loans to cover cash shortfalls in the first quarter of the year? If so, how much money will she have to borrow, and what do you think may have caused this? If Eunice has to borrow a shortterm loan to cover cash shortfalls in the first quarter of the year, will she be able to pay it back in a timely manner? If so, when? By the end of the quarter, will Eunice have a surplus or deficit of cash? If she has a surplus, what should she do with the extra money? Overall, how do you think Eunice is doing at planning her cash receipts and cash disbursements in order to keep enough cash on hand to pay her bills?

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

Question

What is the effect of word war second?

Answered: 1 week ago