Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please make it easy to read. no need for explanation just the answers thank you! Requirements October sales red to be $300.000 Sales are projected
please make it easy to read.
Requirements October sales red to be $300.000 Sales are projected to increase by 10% in November and another 25 in December and then return to the other level nawy 20% of sales are made in cash while the remaining areas by creditor de cards. The credit caries wide and Is charge a 1 ansactions and deposit the amounts peless the transaction for in the show's bank account day. The stor does not accept checks Bea of the payment mechanism of moncayo bad The store's gopro 40% of its los revenue . For the next seven months, there wants to mantain an ending merchandise inventory to $14.000 plus 10% of the next month's cost of goods sold. Al purchases for merchandise are made on Hot and paid in the month folowing the purchase. The Setembro Inventory is expected to be $37,400 Expected monthly operating expenses and details about payments include the following Wages of some workers should be 57.100 per monin and are paid on the last day of each mom. Uits expers is expected to be 1800 per month in Senter, Odoter, and November Unexpense is expected to be 51.700 per month Guring the colder month of December January and Powy . All try bits are paid the month atur incurred. Property tax is $25.200 per year and is paid semiannually each December and one Property and ability insurance 520.400 per year and is paid semiannually each January and Juy Depreciation expense is $120,000 per year, the straight line method used + Transaction fees, as stated earlier are 1 of Cated debit cards Cash dividends of $20,000 to be paid in December Assume the cash balance on October 31 is 560,000. The company wants to mantina cash balance of at least 500.000 at the end of every month The company has stranged a line of credit with a local bank ata 3% interest rate. There is no outstanding debts of October 31 Prepom the wing budget for November Deceber 1. Sales budget 2 Cost of good sold inventory and purchases buget Operating expense budget 4 Budget comment Cashion budget 6. Cash payments budget 7. Combined cash badget 5 Print Done Requirement 1. Prepare the sales budget for November and December Discount Dollar Store Sales Budget For the Months of November and December November December Cash sales Credit sales Total sales Requirement 2. Prepare the cost of goods sold, inventory, and purchases budget for November and December. Discount Dollar Store Cost of Goods Sold, Inventory, and Purchases Budget For the Months of November and December November December Cost of goods sold Plus: Desired ending inventory Total inventory required Less: Beginning inventory Requirement 3. Prepare the operating expense budget for November and December. Discount Dollar Store Cash Payments for Operating Expenses Budget For the Months of November and December November December Wage expense Utilities expense Property tax expense Property and liability insuranse expense Depreciation expense Credit/Debit card fees expense Total operating expenses . . Requirement 4. Prepare the budgeted income statement for November and December. 8 Review the budgets prepared in Requirements 1, 2, and 3. Discount Dollar Store Budgeted Income Statement For the Months of November and December November December Sales revenue Less: Cost of goods sold Gross profit Less: Operating expenses Net income Requirement 5. Prepare the cash collections budget for November and December Review the sales budget prepared in Requirement 1. Discount Dollar Cash Collections Budget For the Months of November and December November December Cash sales Credit sales, net of fees Total cash collections Requirement 6. Prepare the cash payments budget for November and December. (no cash payment is made, make sure to enter "o" in the appropriate coll Review the budgets prepared in Requirements 1, 2 and 3. Discount Dollar Cash Payments for Operating Expenses Budget For the Months of November and December November December 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 Requirement 7. Prepare the combined cath budget for November and December. (Enter a "" for any cono amount. Une parentheses or omission for negative cash balances and funding payments) Review the canh collections and can payments budgets prepared in Requirements 5 and 6 Discount Dollar Combined Cash Budget For the Months of November and December November December Beginning cash baco Plus Cash collections Total cathavaate Less: Cash payments Ending cash balance before financing Financing Plus: New borrowings Les Debt repayment Less Interest payments Ending cash balance no need for explanation just the answers thank you!
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