Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please post the answers complete, thank u in advance. You are the manager of El Yunque Inn. You would like to pay all your employees
Please post the answers complete, thank u in advance.
You are the manager of El Yunque Inn. You would like to pay all your employees a Christmas bonus totaling $10,000 Your owner, Don Papo agrees with your incentive rewards but wants to make sure the Inn will generate enough cash flow in December to pay the $10,000 and still maintain a minimum $5,000 cash balance Based on the following information, prepare a cash budget to determine whether or not you can afford to pay your employees their Christmas bonus, which will be $10,000 in total October November December Credit Sales $ 60,000.00 $ 80,000.00 $ 75,000.00 75% collected in next month $ 45,000.00 $ 60,000.00 $ 56,250.00 25% collected in two months $ 15,000.00 $ 20,000.00 $ 18,750.00 Cash Sales $ 12,500.00 $ 16,390.00 $ 20,590.00 Credit Purchases-paid next month Cash Purchases $ 30,560.00 $ 34,580.00 $ 28,650.00 Cash Purchases $ 3,116.00 $ 2,159.00 $2,489.00 Payroll --35% of total sales $ 25,375.00 $ 33,736.50 $ 33,456.50 Service on mortgage per month $5,000.00 Insurance-prepaid every 3 months $ 3,000.00 Property tax-due in November $ 15,000.00 Step 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