ACC 1820 Project 4 Ch 7 Name Use Question 11 from HW6 on CON

ACC 1820 Project 4 (Ch 7) Name Use Question 11 from HW6 on CONNECT to complete the project requirements. represent check figures provided. items (5 points) Let\'s prepare a balance sheet for Garden Sales, Inc. at the BEGINNING of the quarter- March 31\". The CONNECT problem provides beginning cash, Inventory and accounts payable balance as of March 31. To compicte the balance sheet, we will have to calculate a few balances I) Look at the Schedule of Expected Cash Collections that you completed on CONNECT CONNECT results) Remember the accounts receivable represents the sales that have already been made but payment is expected in the future. What would the accounts receivable balance be as of March 31? a) b) Complete the asset side of the balance sheet including total assets. Include the \"total asset\" amount in the \"total liability & SH Equity\" box. Include the accounts payable amount from CONNECT and calculate the amount of retained earnings such that the c) balance sheet will balance. Garden Sales, Inc Balance Sheet March 31 133ee0 Cash Accounts Receivable Inventory Accounts Payable 13000 Common Stock 100,000 c0 Retained Earnings 350,000 Total SH Equity Total current assets Plant Assets, net Total Assets Total liabilities & SH Equity he company\'s president is concerned about its ability to borrow money on its line of credit. The bank s indicated they will reduce the total loan balance limit to $100,000. Because of this, the president ants to know how increased collection efforts and reduced inventory levels will impact the cash budget e president suggests that sales continue to be 20% for cash and 80% on credit. However, credit sales April, May, and June will be collected over a three-month period with 25% collected in the month of e, 65% collected in the month following sale, and 10% in the second month following sale. This unge in policy will not affect collection of sales from February and March. (Assume those are hanged from your CONNECT problem)

Solution

Direct Labour Budget April May June Quarter Required Production 12400 12183 5600 30183 Direct Labour Time Per unit 2.25 2.25 2.25 Total Labour Hour Required 27900 27412 12600 67912 Hours at base Labour Rate($13) 18000 18000 12600 48600 Hours at overtime Rate($19.5) 4000 4000 0 8000 Hours at Contract Rate($26) 5900 5412 0 11312 Labour cost at base rate 234000 234000 163800 631800 Labour cost at overtime rate 78000 78000 0 156000 Labour cost at contract rate 153400 140706 0 294106 Total Direct Labour cost 465400 452706 163800 1081906