Struggling with this Budget Assignment! Please Help ASAP! We are only expected to cover the FIRST quarter of 2019.

This budget is for Dresden Company who produces a single type of commercial stainless-steel lock. They have estimated total sales of 350,000 locks. This budget will cover the first quarter of the year 2019. January February March April Expected Sales $30,000 $28,000 $33,000 I $32,000 Sales price per unit January beginning inventory 1,500 units Ending Finished Goods inventory 5% of next month's sales Direct material used Stainless steel Direct material used 1.1 pounds per unit Direct material cost $2.30 per pound Desired ending inventory for raw materials 10% of next month's needs Direct labor used .025 per hour per unit Direct labor wage $14.00 10% of sales are collected in cash 40% of credit sales are collected in the month of the sale 30% of credit sales are collected in the month following the sale 20% are collected in the second month after the sale Requirements: Prepare the following budgets in the excel spreadsheet provided: 1. Sales Budget 2. Production Budget 3. Purchases Budget 4. Direct Labor Budget 5. Cash Collections Budget