Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(A) surs scutbutr begin{tabular}{|c|c|c|c|c|c|c|c|} hline & MARC: & APeat & Mar & JukE & suly & MUCUST & APEILToJutY hline Selhedide t: Sulve Ferocind

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
(A) surs scutbutr \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & MARC: & APeat & Mar & JukE & suly & MUCUST & APEILToJutY \\ \hline Selhedide t: Sulve Ferocind & 2000 & 11500 & tatan & & 11500 & & 552000 \\ \hline Credt inles. 40% & 36,00 & 6000 & nese & , 00 & 45000 & & \\ \hline Castrales, 00s & & thoos & 110,400 & 82.800 & 6000 & & \\ \hline \multicolumn{8}{|l|}{ Sebedule z Cant Cellectlon: } \\ \hline Cask sales this mens & & & 110,400 & & x & & \\ \hline & & & & & & & \\ \hline salet & & & & nieg & & & \\ \hline Tatal collectiena & & 105100 & 19400 & 198400 & 524300 & & \\ \hline \end{tabular} (e) pucuasts scurduLe \begin{tabular}{|c|c|c|c|c|c|c|} \hline & MARCM & APsil & MaY & JUN & JutY & ApRiLToJutY \\ \hline \multicolumn{7}{|l|}{ Sehodule 2 Rrechases } \\ \hline Ending invelary & 110.4x & tescas & tran20 & 110,400 & 97500 & \\ \hline Cent ef poots veld & sen & 1050 & & & & \\ \hline Total resdod & & 28540 & 252000 & & moses & \\ \hline Beginimg isvestany & & -11040 & -142149 & & -11000 & \\ \hline Parthasen & & 119160 & lanods & 2000 & 5700 & \\ \hline \multicolumn{7}{|l|}{Seledule&PurchateDinberementh} \\ \hline SW of last nenary porchases & & & & 5+500 & 41MeO & \\ \hline Whe of this nombir purchaset & & & 51500 & 490 & 39) & \\ \hline Ditboriements for purchasen & & & t1tox & mas & 7nasp & \\ \hline \end{tabular} 1. The PDC Company was described earlier in this chapter. Refer to the PDC Company's projected monthly operating schedules in Table 6.2. PDC's sales are projected to be $80,000 in September 2020 . A. Prepare PDC's sales schedule, purchases schedule, and wages schedule for August 2020. B. Prepare a cash budget for August 2020 for PDC and describe how the forecast affects the end-of-the-month cash balance. Figure 6.2 Graphic Portrayal of Cash Balance Volatility as a Successful Venture Progresses through Its Life Cycle Details (C) WACES AND COMMISSIONS SCHEDULE \begin{tabular}{|c|c|c|c|c|c|c|} \hline & MAECH & UL & May & JUNE & sutr & APRILTOJUEY \\ \hline \multicolumn{7}{|l|}{ScheduleS:WagetandConnaiszies} \\ \hline Wages, all freed & 5,750 & 5,750 & 5,750 & & 5,750 & \\ \hline Comeisaions(15%ofcurrentswles! & 13/00 & 10299 & 21700 & 2000 & 17250 & \\ \hline Toeal & 1950 & 23000 & 33350 & 25.450 & 2300 & 105,300 \\ \hline \multicolumn{7}{|l|}{Schedule6.Disburnenionts-WapesandComaissions} \\ \hline SOS of last moathis expentses & & & 11,500 & thess & 13,ns & \\ \hline sow ef thit moothis expeases & & 11,500 & 165075 & 1328s & 11,500 & \\ \hline Total & & 21205 & 29175 & & 24,75 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & APQiL & MAY & SUNE. & JUtY \\ \hline Beginning cast belance & 2300 & 2000 & 23000 & 28000 \\ \hline \multicolumn{5}{|l|}{ Cash recteipts: } \\ \hline Collactions from custoners & 105,000 & 156.400 & 156.400 & 124>00 \\ \hline Totaltahavalatleforneefsbeforefinancing & & 179,490 & 179,400 & 147,200 \\ \hline \multicolumn{5}{|l|}{ Cath fisburiamentx: } \\ \hline Merchatisiae & 9610 & 111,090 & 90300 & 75,670 \\ \hline Wages and comminsions & 21,275 & 25.175 & 22900 & 24725 \\ \hline Mucellaneous expenses & 5750 & 9,200 & 6990 & 5.750 \\ \hline Rent & 4100 & 4600 & 4f00 & 4f00 \\ \hline Tretk purchase & 6.900 & 0 & 0 & 0 \\ \hline Total dsbursements & 136,735 & 153065 & 134780 & 110345 \\ \hline Minimum cash balance desired & 2300 & 23000 & 23000 & 2000 \\ \hline Total cauth needed & I9A7s & 126005 & 15750 & 10745 \\ \hline Excess of total eash & -30995 & 3x05 & 21,680 & 13,458 \\ \hline \multicolumn{5}{|l|}{ Financing } \\ \hline New borrowing & 30995 & 0 & 0 & 0 \\ \hline Resaymants & & 287 & 21.19 & 6865 \\ \hline Loan balance & 30905 & 21064 & 6.855 & 0 \\ \hline Interast & 0 & 464 & 421 & 10 \\ \hline Total eflects of finascing & 30.965 & 3,305 & -21680 & \\ \hline Cash balance & 23000 & 23000 & 20,00 & 29,437 \\ \hline \end{tabular}

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Accounting questions

Question

Identify four applications of HRM to healthcare organizations.

Answered: 1 week ago