Question: Dollar Saver Store is a local discount store with the following information: ( Click the icon to view the information. ) Read the requirements.

Dollar Saver Store is a local discount store with the following information:
(Click the icon to view the information.)
Read the requirements.
\table[[Purchases of inventory, 30 day lag,],[Cash payments for wages,],[Cash payments for utilities,],[Cash payments for property taxes,],[Cash payments for dividends,],[Property and liability insurance,],[Total payments for operating expenses,]]
Data table
October sales are projected to be $390,000.
Sales are projected to increase by 10% in November and another 25% in December and then return to the October level in January.
20% of sales are made in cash while the remaining 80% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 1% transaction fee, and deposit the net amount (sales price less the transaction fee) in the store's bank account daily. The store does not accept checks. Because of the payment mechanisms, there is no risk of non-payment or bad-debts.
The store's gross profit is 40% of its sales revenue.
For the next several months, the store wants to maintain an ending merchandise inventory equal to $16,000 plus 10% of the next month's cost of goods sold. All purchases for merchandise are made on account and paid in the month following the purchase. The September 30 inventory is expected to be $39,400.
Requirement 7. Prepare the combined cash budget for November and December financing payments.)
Review the cash collections and cash payments budgets prepared in Requiremen
Dollar Saver
Combined Cash Budget
For the Months of November and December
The company wants to maintain a cash balance of at least $15,000 at the end of every month. The company has arranged a line of credit with a local bank at 3% interest rate. There is no outstanding debt as of october 31. PLEASE HELP WITH REQUIRMENT 6 WHAT IS THE PURCHASE OF INVENTORY 30 DAY LAG?!?! COMPLETE THE CHART PLEASE FOR REQUIRMENT 6AND7!!!
 Dollar Saver Store is a local discount store with the following

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!