加里森管理会计第16版最新英文版配套Excel习题Chapter_9_Applying_Excel
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
1,800 $ 29,700 $ 1,650 F
Planning Budget
1,700 $ 28,050
11,250 10,400
1,160 2,200 2,040 27,050 $ 2,650 $
625 U -
20 U -
80 U 725 U 925 F
10,625 10,400
1,140 2,200 1,960 26,325 $ 1,725
meals 1,700 served
meals 1,800 served
Enter a formula into each of the cells marked with a ? below Review Problem: Variance Analysis Using a Flexible Budget
Page 1Hale Waihona Puke Baidu
3147426112.xls
Chapter 9: Applying Excel
Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous
$10,400
$800
+
$2,200
$600
+
$16.50 q $6.25 q
Construct a flexible budget performance report
Meals served Revenue Expenses: Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Total expenses Net operating income
Revenue and
Actual Spending Results Variances
1,800 $ 28,900 $ 800 U
11,300 10,300
1,120 2,300 2,020 27,040 $ 1,860 $
50 U 100 F
40 F 100 U
20 F 10 F 790 U
Flexible Activity Budget Variances
$0.20 q
$0.80 q
Actual results: Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous
$28,900 $11,300 $10,300
$1,120 $2,300 $2,020
Planning budget activity Actual activity
Planning Budget
1,700 $ 28,050
11,250 10,400
1,160 2,200 2,040 27,050 $ 2,650 $
625 U -
20 U -
80 U 725 U 925 F
10,625 10,400
1,140 2,200 1,960 26,325 $ 1,725
meals 1,700 served
meals 1,800 served
Enter a formula into each of the cells marked with a ? below Review Problem: Variance Analysis Using a Flexible Budget
Page 1Hale Waihona Puke Baidu
3147426112.xls
Chapter 9: Applying Excel
Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous
$10,400
$800
+
$2,200
$600
+
$16.50 q $6.25 q
Construct a flexible budget performance report
Meals served Revenue Expenses: Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Total expenses Net operating income
Revenue and
Actual Spending Results Variances
1,800 $ 28,900 $ 800 U
11,300 10,300
1,120 2,300 2,020 27,040 $ 1,860 $
50 U 100 F
40 F 100 U
20 F 10 F 790 U
Flexible Activity Budget Variances
$0.20 q
$0.80 q
Actual results: Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous
$28,900 $11,300 $10,300
$1,120 $2,300 $2,020
Planning budget activity Actual activity