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...
-
What is the after-tax interest rate that a corporation in the 38 percent tax bracket pays on a loan of $100,000 at 7 percent interest?
-
Criminals are basically stupid, because anyone who isnt basically stupid wouldnt be a criminal. Identify the fallacies of relevance, weak induction, presumption, ambiguity, and illicit transference...
-
The following information has been extracted from the financial statements and notes thereto of Bass and Dide Ltd, consultants. Required (a) Calculate the following ratios for 2025: i. return on...
-
This problem is a continuation of P5-35. Mortar Corporation acquired 80 percent ownership of Granite Company on January 1, 20X7, for $173,000. At that date, the fair value of the noncontrolling...
-
Evaluate (g(t)) using the Chain Rule: r(t)=(e, est,-9), g(t) = 8t+2 (9(t))=000
-
1:- As a result of MEXIT, Telford Engineering had lost 30% of its pre-MEXIT export sales to CETA customers, due to increased trade and tariff barriers with CETA. (See P/L account before MEXIT in the...
-
Find the equivalent present worth of the following cash flows where i = 6.9%. In other words, how much do you have to deposit now at Year O (with a second deposit as shown at the end of the first...
-
Under line sensory words. The Big Mac is a juicy, delicious burger that will leave you feeling satisfied. The bun is soft and fluffy, and the beef is cooked to perfection. The secret sauce is the...
-
How do feminist perspectives offer unique insights into the intersections between gender, power, and deviance, particularly concerning issues such as sexual violence and patriarchal social structures...
-
You want to be able to withdraw the specified amount periodically from a payout annuity with the given terms. Find how much the account needs to hold to make this possible. Round your answer to the...
-
What is the chemical formula of fructose? Have a look at the molecular structure. a) C5H206 b) CHO5 c) C6H2O5 d) C6HO6
-
Your portfolio which consists of 45% of stock J, and 55% of stock K. J has daily Standard Deviation 2% while K has daily Standard Deviation 3%. The correlation of two stocks is -0.5. What is the 1...
-
Describe and explain in detail The Need for Effective Leadership Explain in detail Defining Leadership & Emergent Leadership Describe and explain in detail The New Reality for Leaders Explain in...
-
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?
-
During a reversible isobaric non-flow process with \(p=1.5\) bar the properties of the system change from \(0.25 \mathrm{~m}^{3} / \mathrm{kg}, 10^{\circ} \mathrm{C}\) to \(0.45 \mathrm{~m}^{3} /...
-
A mass of \(8 \mathrm{~kg}\) gas expands within a flexible container according to the law, \(p V^{1.5}=\) const. The initial pressure is \(1 \mathrm{MPa}\) and initial volume is \(1...
-
A mass of air is initially at \(260^{\circ} \mathrm{C}\) and \(700 \mathrm{kPa}\), and occupies \(0.028 \mathrm{~m}^{3}\). The air is expanded at constant pressure to \(0.084 \mathrm{~m}^{3}\). A...
Study smarter with the SolutionInn App