Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please i need the answer asap please Excel File Edit Edit View Insert Format Tools Data Window Help O ) U.S. 91% 91% O Sun
please i need the answer asap please
Excel File Edit Edit View Insert Format Tools Data Window Help O ) U.S. 91% 91% O Sun 12:20 PM Q5 3 (1).xls Q- Search in Sheet Quick Search Format Cells Themes Normal X ! DE DDDDD Bad Insert Delete Format Themes Aa, K L M N o P - 2 Y fx 87% ? New Templates Open Save Print Cut Copy Paste Format Undo Redo AutoSum Sort Filter Formula Bar Toolbox Media Zoom Help A Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Number Fill Arial MT - 12 - A- A- abc Wrap Text General Clear Paste U A ... ,00 Merge - % % ) 4.0 Conditional -.0 .00 Formatting 113 X fx A B D E F G H 9 Budget Data 10 Fixed Variable Actual 11 Portion Portion* Data 12 Depreciation FORMULA1 $5,000 13 Maintenance $2,000 $0.80 4,930 14 Inspections $3,000 0.30 3,902 15 Utilities $4,500 0.30 5,400 16 Indirect material FORMULA2 1.125 17 Overtime 2.50 ** 260 18 19 *per direct labor hour 20 **per monthly direct labor hours in excess of 4,500 21 22 Planned direct labor hours for the month 5,000 23 Actual direct labor hours for the month 4,600 24 25 Answer Section 26 27 Static Budget Budget Actual Difference 28 Depreciation $5,000 $5,000 $0 29 Maintenance FORMULA3 0 0 30 Inspections FORMULA4 0 0 31 Utilities FORMULAS 0 0 32 Indirect material 1,500 1,125 375 33 Overtime FORMULA6 260 -260 34 $6,500 $6,385 $115 35 36 Flexible Budget Budget Actual Difference 37 Depreciation $5,000 $0 38 Maintenance FORMULAZ 0 0 39 Inspections FORMULAS 0 0 0 40 Utilities FORMULAS 0 0 41 Indirect material 1,380 1,125 255 42 Overtime FORMULA10 260 -260 43 $6,380 $6,385 ($5) Worksheet Chart + Normal View Ready Sum-0 $5,000 DELO 17 TO AN TO goStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started