Answered step by step
Verified Expert Solution
Link Copied!

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.
no need for explanation just the answers thank you!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services Plus Pearson MyLab Accounting With Pearson EText

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

17th Global Edition

1292312106, 978-1292312101

More Books

Students also viewed these Accounting questions