PDCs sales are projected to be $80,000 in September 2020. Prepare PDCs sales schedule, purchases schedule, and
Fantastic news! We've Found the answer you've been seeking!
Question:
PDC’s sales are projected to be $80,000 in September 2020.
Transcribed Image Text:
(AI SALES SCHEDULE APRIL TO MARCH APRIL MAY JUNE JULY AUGUST JULY Schedule 1: Sales Forecast 92,000 115,000 184,000 138,000 115,000 92,000 552,000 Credit sales, 40% 36,800 46,000 73,600 55,200 46,000 Cash sales, 60% 55,200 69,000 110,400 82,800 69,000 Schedule 2: Cash Collections Cash sales this month 69,000 110,400 82,800 69,000 100% of last month's credit sales 36,800 46,000 73,600 55,200 Total collections 105,800 156,400 156,400 124,200 (B) PURCHASES SCHEDULE APRIL TO APRIL MAY MARCH JUNE JULY JULY Schedule 3: Purchases Ending inventory 110,400 149,040 123,280 110,400 97,520 Cost of goods sold 64,400 80,500 128,800 96 800 80,500 386 400 Total needed 174,800 229,540 252,080 207,000 178,020 Beginning inventory -97,520 -110,400 -149,040 -123,280 -110,400 Purchases 280ר7 119,140 103,040 83,720 67 620 Schedule 4: Purchase Disbursements 50% of last month's purchasos 38,840 59,570 51,520 41,860 50% of this month's purchases 59.570 51,520 41,860 33,810 Disbursements for purchases 98,210 111,090 93,380 75,670 (C) WAGES AND COMMISSIONS SCHEDULE APRIL TO MARCH APRIL MAY JUNE JULY JULY Schedule 5: Wages and Commissions Wages, all fixed 5,750 5,750 5,750 5,750 5,750 Commissions (15% of current sales) Total 13,800 17.250 27.600 20,700 17,250 19,50 23,000 33,350 26,450 23,000 105,800 Schedule 6: Disbursements- Wages and Commissions 50% of last month's expenses 9,775 11,500 16,675 13,225 50% of this month's expenses 11,500 16,675 13,225 11,500 Total 21,275 28,175 29,900 24,725 (AI SALES SCHEDULE APRIL TO MARCH APRIL MAY JUNE JULY AUGUST JULY Schedule 1: Sales Forecast 92,000 115,000 184,000 138,000 115,000 92,000 552,000 Credit sales, 40% 36,800 46,000 73,600 55,200 46,000 Cash sales, 60% 55,200 69,000 110,400 82,800 69,000 Schedule 2: Cash Collections Cash sales this month 69,000 110,400 82,800 69,000 100% of last month's credit sales 36,800 46,000 73,600 55,200 Total collections 105,800 156,400 156,400 124,200 (B) PURCHASES SCHEDULE APRIL TO APRIL MAY MARCH JUNE JULY JULY Schedule 3: Purchases Ending inventory 110,400 149,040 123,280 110,400 97,520 Cost of goods sold 64,400 80,500 128,800 96 800 80,500 386 400 Total needed 174,800 229,540 252,080 207,000 178,020 Beginning inventory -97,520 -110,400 -149,040 -123,280 -110,400 Purchases 280ר7 119,140 103,040 83,720 67 620 Schedule 4: Purchase Disbursements 50% of last month's purchasos 38,840 59,570 51,520 41,860 50% of this month's purchases 59.570 51,520 41,860 33,810 Disbursements for purchases 98,210 111,090 93,380 75,670 (C) WAGES AND COMMISSIONS SCHEDULE APRIL TO MARCH APRIL MAY JUNE JULY JULY Schedule 5: Wages and Commissions Wages, all fixed 5,750 5,750 5,750 5,750 5,750 Commissions (15% of current sales) Total 13,800 17.250 27.600 20,700 17,250 19,50 23,000 33,350 26,450 23,000 105,800 Schedule 6: Disbursements- Wages and Commissions 50% of last month's expenses 9,775 11,500 16,675 13,225 50% of this month's expenses 11,500 16,675 13,225 11,500 Total 21,275 28,175 29,900 24,725
Expert Answer:
Answer rating: 100% (QA)
a Sales Schedule 1st schedule Sales Prediction Total sale 92000 Debt sales 40 36800 Sales amount 60 ... View the full answer
Related Book For
New Venture Creation Entrepreneurship for the 21st Century
ISBN: 978-0078029103
9th edition
Authors: Stephen Spinelli, Rob Adams
Posted Date:
Students also viewed these finance questions
-
Online sales are projected to increase. Should Laura consider this as a more viable channel to explore? How can she drive customers to the website?
-
Describe how balance sheets are projected once a sales forecast has been made.
-
prepare a classified balance sheet for the month ending August On the 1st of August, Brothers haircut had these transactions during this month. On August 2, Paid $2200 cash for August salon rent. On...
-
Jimmy and Elizabeth plan on getting married on the 15th of August. Elizabeth decides that she would prefer to have the reception in her backyard, so she rents an event tent from CELEBRATE Ltd, a firm...
-
The Promise Software Engineering Repository is a collection of data sets available to serve businesses in building predictive software models. One such data set, saved in the accompanying file,...
-
(a) Explain the following methods of payment that could be used by a multinational corporation (MNC) to settle international transactions: Required: (i) Prepayment. (2 marks) (ii) Letters of credit...
-
What are the advantages and disadvantages of e-learning?
-
Mattel is a U.S.-based company whose sales are roughly two-thirds in dollars (Asia and the Americas) and one-third in euros (Europe). In September Mattel delivers a large shipment of toys (primarily...
-
Find the units digit of 329 +1112 +15. modulus n, an
-
(a) Could 25 g of argon gas in a vessel of volume 1.5 dm3 exert a pressure of 2.0 bar at 30C if it behaved as a perfect gas? If not, what pressure would it exert? (b) What pressure would it exert if...
-
The shown mono-slope roof structure is to be designed as a fully enclosed building and as an essential facility in the municipality of Vieques, PR. The building will be located on the open flat...
-
A 4.21 g sample of an unknown salt (MM 116.82 g/mol) is dissolved in 150.00 g water in a coffee cup calorimeter Before placing the sample in the water, the temperature of the salt and water is 23.72...
-
Complete the following table. Functional Group Name Sample Functional Group R-OH R R' R Naming Rule) name the chain that came from the alcohol first name the carboxylic acid second and end with...
-
A horizontal nozzle has an inlet velocity v and an outlet velocity v2 and discharges into the atmosphere. Show that the outlet velocity can be expressed by the following formulae: V2 v = 22 2 2gAh +...
-
9.13 A vortex shedding transducer is being designed to measure the velocity of water flowing in an open channel. The range of velocities to be measured is from 0.10 to 10.0 fts. The relationship...
-
19. A machine shaft, supported on bearings having their centres 750 mm apart, transmitted 185 kW at 600 r.p.m. A gear of 200 mm and 20 tooth profile is located 250 mm to the right of left hand...
-
1.Imagine that you are a new hire at a commercial bank who has just completed her first performance review. Given that this entity believes in using the most modern approaches and systems, discuss...
-
SCHEDULE OF COST OF GOODS MANUFACTURED The following information is supplied for Sanchez Welding and Manufacturing Company. Prepare a schedule of cost of goods manufactured for the year ended...
-
Why do you think the public franchisors consistently outperformed the S&P 500?
-
What special problems and crises can new ventures expect as they grow? Why do these occur?
-
In what ways does looking through a sustainability lens change how an entrepreneur approaches a new venture opportunity?
-
Cress Trust owns houses in Marion County, for whom Rainbow Realty Group, Inc., sells, rents, and manages. The same person serves as Rainbows president and Cresss corporate trustee. Cress offers four...
-
Genevieve and William Timmons began their tenancy of a ground-floor apartment at Cobblestone Square in September 2011. Kingsley-Johnston, Inc., is a property management company responsible for...
-
Linda Miller rented 35 acres of pastureland in Wabaunsee County, Kansas, from William Burnett for $1,000 per year. Miller and her husband used the land to grow and harvest brome grass for their...
Study smarter with the SolutionInn App