In session 5 (chapter 6) you have studied case studies from PDC companies relating to short-term cash planning and financial statement projections. The following is PDC Company's sales projection from December 2018-July 2019: December 2018 $ 160,000 January 2019 $ 700,000 February 2019 $ 900,000 March 2019 $ 1,000,000 April 2019 $ 1,100,000 May 2019 $ 1,400,000 June 2019 $ 1,500,000 July 2019 $ 1,700,000 Here's an informative flashback of the company's PDC policy in question Short-term cash planning and financial statement projections in Chapter 6: PDC company sales have a composition of 60% in the form of cash sales while 40% in the form of credit sales. Credit sales will be paid off by the consumer in the following month after they make a purchase at the PDC Company. Cost of goods sold (cost of goods sold sold) at 70% of the projected sales for the current month (current month). Policy ending inventory per month: projected next month sales x 80% x 70% + soft inventory for $ 46,000. This policy was taken so that the PDC Company ending inventory could be carried out cover the beginning of the following month by 80%, able to cover the cost of goods sales of 70%, and keeps a $ 46,000 soft stock at the end of each month. Payment for the purchase of raw materials is divided into two periods, namely 50% payment in a month this and the balance is paid the following month. The basic salary for employees is set every month Namely, $ 5,750, while the commission is paid on the basis of 15% of the month's sales running (this month). The total salary and commission is paid twice. Total salary and commission for the month the current component consists of 50% of the salary and commission for the month and 50% of the salary and commission paid previous month. Other expenses are set at 5% of this amount sales projections for this month (this month). The building lease is determined at a monthly rate of $ 4,600. In the period January - June 2019 PDC The company decided to stop buying trucks (fixed assets). Loan interest 1.5% per month applies. Payment of loan installments and interest is made at the end month. Depreciation expense is S1,150 per month. Insurance expense per month is $ 460. Prepaid insurance PDC Company, the balance is deducted automatically per month for $ 460. After the insurance balance is prepaid the value is 0, the new PDC company will make insurance repayments for 1 year. For the sake of simplicity of calculation, hence tax calculations are not included in this case study. Based on the information above and some additional information below, do it following instructions: Suppose that the beginning December 2018 inventory is $ 135,600 and the ending inventory is December 2018 is S152.400, then show me the preparation of a sales schedule, purchase schedule, wages and commissions schedule, and cash budget from January - June 2019. b. Here is some additional information about the PDC Company. Insurance balance in prepaid insurance for January 2019 is S5520. Value of fixed assets (equipment, fixture & others) December 2018 is S92.00. PDC Company decided none purchase of fixed assets during January - June 2019. Accumulated depreciation value December 2018 is $ 39,790. December 2018 common stock (owner's equity) was S184,357. The number of common shares from January to April 2019 is calculated by adding up previous month's common stock with current month's profit. Several special events resulted in the value of the common shares for May 2019 to S13,625 and the value of the common stock for June 2019 was $ 37,155. Suppose the PDC Company stipulates the amount of the loan (loan) as below: January 2019 $ 15,608 February 2019 $ 310,158 March 2019 $ 284,757 April 2019 $ 294,607 May 2019 $ 50,000 $ 50,000 Then compile the projected income statement and balance sheet for January - June 2019 with reference June 2019 in the additional information in point b and the information in the question narrative. c. Based on the answers in points a and b, compare the cash projection conditions in table 6.2 with the results of your calculations. Do an analysis of the things that cause change PDC Company's cash condition d. Based on the answers to points a & b, give predictions about the sustainability of the business venture PDC Company. Also give recommendations to the PDC Company so that they can survive.