29 A 1 Pat Smith is the founder and president of Pat Products 2 Pat called their child, Sam who is the sales manager, into their office to discuss their perform 3 A static budget report has been prepared. 4 5 Pat Products Static Budget Report 7 Month Ended October 31, 2020 8 9 Static 10 Budget Actual Varlance 11 Sales in units 8,000.00 9,000.00 12 Variable costs: 13 Sales commissions $ 2,800.00 $ 3,000.00 $ 200.00 U 14 Travel expense $ 2,400.00 $ 2,400.00 $ 15 Meals expense $ 1,300.00 $ 1,500.00 $ 200.00 U 16 Entertainment expense $ 4,000.00 $ 3,600.00 $ 400.00 F 17 Total variable costs $10,500.00 $ 10,500.00 $ 18 Fixed costs: = rmula Sheet Part1 - MCQ - Theory (12 marks) Part2 - MCQ - Calc. (7 marks) Calculation Mode: Automatic Workbook Statistics 1,500.00 S 21 22 Required: 23 a) Prepare a flexible budget for October in good form.49 marks) 24 b) Should Sam be praised or reprimanded for their performance in October? (1 mark) expense which stayed the same. Actual fixed costs did not change from September. Prepare a fiexible budget 25 for November (5 marks) 26 d) Comment on Sam's performance in November. (1 mark) sa mata 29 A 1 Pat Smith is the founder and president of Pat Products 2 Pat called their child, Sam who is the sales manager, into their office to discuss their perform 3 A static budget report has been prepared. 4 5 Pat Products Static Budget Report 7 Month Ended October 31, 2020 8 9 Static 10 Budget Actual Varlance 11 Sales in units 8,000.00 9,000.00 12 Variable costs: 13 Sales commissions $ 2,800.00 $ 3,000.00 $ 200.00 U 14 Travel expense $ 2,400.00 $ 2,400.00 $ 15 Meals expense $ 1,300.00 $ 1,500.00 $ 200.00 U 16 Entertainment expense $ 4,000.00 $ 3,600.00 $ 400.00 F 17 Total variable costs $10,500.00 $ 10,500.00 $ 18 Fixed costs: = rmula Sheet Part1 - MCQ - Theory (12 marks) Part2 - MCQ - Calc. (7 marks) Calculation Mode: Automatic Workbook Statistics 1,500.00 S 21 22 Required: 23 a) Prepare a flexible budget for October in good form.49 marks) 24 b) Should Sam be praised or reprimanded for their performance in October? (1 mark) expense which stayed the same. Actual fixed costs did not change from September. Prepare a fiexible budget 25 for November (5 marks) 26 d) Comment on Sam's performance in November. (1 mark) sa mata