Build a spreadsheet construct an excel spreadsheet to solve

Assignment Help Accounting Basics

Reference no: EM13602734

70 percent collected in the month of sales
15 percent collected in the first month after sale
10 percent collected in the second month after sale
4 percent collected in the third month after sale
1 percent uncollectible

The sales on account have been budgeted for the last seven months as follows:
June-.......122,500 Sep...200,000 Dec....212,500
July.........150,000 Oct...225,000
August......175,000 Nov...250,000

1. Compute the estimated total cash collectons during October from credit sales
2. Compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter
3. Build a spreadsheet: Construct an Excel spreadsheet to solve both of the preceeding requirements SHow how the solution will change if the following information changes: sales in June and July were $100,000 and $130,000 respectively.

Reference no: EM13602734

Questions Cloud

Compute the effect on firm-wide income if 40000 components : the adam division produces a component that is used by the west division. the cost of manufacturing the component is as

Nordstrom company reported net income of 195000 for 2011 : nordstrom company reported net income of 195000 for 2011. nordstrom also reported depreciation expense of 45000 and a

A firm has consistently adjusted its allowance account at : a firm has consistently adjusted its allowance account at the end of the fiscal year by adding a fixed percent of the

On some jobs it is necessary to use outside experts for : emily estimated that she will need to spend 16 hours each month on business development and networking 40 hours per

Build a spreadsheet construct an excel spreadsheet to solve : 70 percent collected in the month of sales15 percent collected in the first month after sale10 percent collected in the

Dresser companys weekly payroll paid on fridays totals : dresser companys weekly payroll paid on fridays totals 6200. employees work a 5-day week. prepare dressers adjusting

Adjusting entries data relating to the balances of various : adjusting entries data relating to the balances of various accounts affected by adjusting or closing entries appear

The west division has been buying the same component from : the adam division produces a component that is used by the west division. the cost of manufacturing the component is as

Dresser companys weekly payroll paid on fridays totals 6200 : dresser companys weekly payroll paid on fridays totals 6200. employees work a 5-day week. prepare dressers adjusting

User Account

All Pages