1 REQUIREMENTS 3 Prepare, in good form, a Master Budget which includes the follo

Question

1 REQUIREMENTS 3 Prepare, in good form, a Master Budget which includes the following: 4 1) Sales Budget 5 2) Production Budget 6 3) Direct Materials Purchases Budget 74) Direct Labour Cost Budget 8 5) Factory Overhead Cost Budget 9 6) Cost of Goods Sold Budget 10 7) Selling and Administrative Expenses Budget 11 8) Budgeted Income Statement 12 9) Schedule of Collections from Sales 13 10) Schedule of Payments for Manufacturing Costs 14 15 Budgets should be for the individual three (3) months of the first quarter of 2019. 16, include a quarterly total column on the right side. (except for #6 and #8). 17 181 Budgets #6 and #8 are for the first quarter only. 19 20 Each budget/requirement should be in a separate tab within one spreadsheet. 21 All pages should be in portrait format using the same font. 22 Please staple your printed copy in the upper left corner. 23 Do not put the sheets into plastic or a binder. 24 25 Treat this as you would any other professional document you are presenting 26 to a client or employer.

Explanation / Answer

(a) Preparation of the sales budget for the month of Jan., Feb & March.We have,

BOTTAS MANUFACTURING INC.

SALES BUDGET

For the quater ending March 31, 2019

(b) Preparation of the production budget for the month of Jan., Feb & March.We have,

BOTTAS MANUFACTURING INC.

PRODUCTION BUDGET

For the quater ending March 31, 2019

(c) Preparation of the direct material purchase budget for the month of Jan., Feb & March.We have,

BOTTAS MANUFACTURING INC.

Direct Material Purchases BUDGET

For the quater ending March 31, 2019

(d)Preparation of the labor budget for the month of Jan., Feb & March.We have,

BOTTAS MANUFACTURING INC.

LABOR BUDGET

For the quater ending March 31, 2019

Particulars January February March Quarter Expected unit sales 7,450 7,090 8,320 22,860 Unit selling price 59.99 59.99 59.99 59.99 Total sales $ 446,925 $ 425,329 499,117 $ 1,371,371

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.