INTRODUCTION TO MANAGEMENT ACCOUNTING 16E Problem 7-30 Name Section A D E G H B C 5 Data Input Section: Lumber Yard Amount 7 Accounts receivable, May 31 8 Monthly forecasted sales: June 10 July 11 August 12 September 13 Credit sales % 14 Cash sales 96 15 Output Section: Amount Amount Amount Amount Amount Amount Total June Formula 1 Formula 2 S - 18 Credit sales 19 Cash sales 20 Total sales Sales Budget July August Formula 3 Formla 5 Formula 4 Formula 6 S - S S Total 24 Cash sales this month 25 100% of last month's credit sales 26 Total collections June Formula 7 Formula 8 Cash Collections Budget July August Formula 9 Formula 11 S Formula 10 Formula 12 - S - S preadsheet to the assignment 3 area G H E ments/555409#submit A B C 5 Data Input Section: D F Lumber Yard Amount 7 Accounts receivable, May 31 8 Monthly forecasted sales: 9 June 10 July 11 August 12 September 13 Credit sales % 14 Cash sales % 15 Output Section: Amount Amount Amount Amount Amount Amount 16 17 Total 18 Credit sales 19 Cash sales 20 Total sales S Sales Budget July August Formula 3 Formula 5 Formula 4 Formula 6 S - S - June Formula 1 Formula 2 - S Total 24 Cash sales this month 25 100% of last month's credit sales 26 Total collections June Formula 7 Formula 8 S . Cash Collections Budget July August Formula 9 Formola 11 S Formula 10 Formula 12 S - S - S End of Problem spreadsheet to the assignment 3 area