Prepare the following schedules in Excel for Nunan Ltd 1 Sales Budget and Schedule of Expected Cash Collections Check July cash collections 492000 2 Production Budget Check required production in July is 3690 units 3 Direct Materials Budget Check required purchases in July 7434 metres of raw material 4 Expected Cash Disbursements for Raw Materials 5 Direct Labour Budget Check July direct labour cost is 110700 6 Manufacturing Overhead Budget 222800 is the three month total for cash disbursements

Answer rating: 100% (QA)

Schedule of expected cash collection April May June Total Feb... View the full answer