Question

Tichina Scales S E AutoSave A 8 - = scales_Miller-Nobles_6e-12e-Using Excel_Ch22_Start - Protected View - Excel The Home Insert Draw P age Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful tiles from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View Enable Iditing A1 X ✓ MASTER BUDGETS F A B C D E T J K L M N O P R S T 9 Requirements Possible Points 10 1. Prepare a Sales Budget 11 2 . Prepare a Production Budget. 12 3. Prepare a Direct Materials Budget 13 4. Prepare a Direct Labor Budget. 5. Prepare a Manufacturing Overhead Budget. 15 6. Prepare a Cost of Goods Sold Budget. 7. Prepare a Selling and Administrative Expense Budget. 14 S88 88 16 18 19 Excel Skills 20 1. Create formulas with cell references 2. Use the ROUND function, 4 Saving & Submitting Solution 5 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Instructions ENTERANSWERS

Answer 1

There are more than 4 parts hence only 4 parts are answered

Budget #1: Sales Budget	2018
	Jan	Feb	Mar	Apr	May
Budgeted units to be sold (A)	18,000	24,000	30,000	34,000	36,000
Sales Price per unit (B) ($)	34	34	34	34	34
Tota Sales (A*B)	6,12,000	8,16,000	10,20,000	11,56,000	12,24,000
Budget #2: production Budget	2017	2018
	Dec	Jan	Feb	Mar	Apr	May
Budgeted units to be sold (A)		18,000	24,000	30,000	34,000	36,000
Plus: Desired units in ending inventory (B)	-	4,800	6,000	6,800	7,200
Total units needed (A+B)= C		22,800	30,000	36,800	41,200
Less: Units in beginning inventory (D)		-	4,800	6,000	6,800
Budgeted units to be produced (C-D)		22,800	25,200	30,800	34,400
Budget #3: Direct Material Budget	2018
	Jan	Feb	Mar	Q1 Total	Apr
Budgeted units to be produced	22,800	25,200	30,800	78,800	36,000
Direct Materials (pounds) per unit	2	2	2	-	2
Direct Materials needed for production	45,600	50,400	61,600	1,57,600	2,69,600
Plus: desired direct materials in ending inventory (pound)	12,600	15,400	39,400	67,400
Total direct materials needed	58,200	65,800	1,01,000	2,25,000
Less: Direct materials in beginning inventory (pound)	9,500	12,600	15,400	37,500
Budgeted purchase of direct materials	48,700	53,200	85,600	1,87,500
Direct material cost pe pound	4	4	4
Budgeted cost of direct materials purchases	1,94,800	2,12,800	3,42,400	7,50,000
Budget #4: Direct labour Budget	2018
	Jan	Feb	Mar	Q1 Total
Budgeted units to be produced	22,800	25,200	30,800	78,800
Direct labour hours per unit	0.5	0.5	0.5	-
Direct labour hours needed for production	11,400	12,600	15,400	39,400
Direct labour cost per hour	20	20	20	-
Budgeted direct labour cost	2,28,000	2,52,000	3,08,000	7,88,000