Planning and actual budgets for the month ended December 31st, 2020 PLANNING ACTUAL Budgeted meals quantity (q) 20 000 18 000 Revenues (£5.00q) £100 000 £90 000 Expenses: Raw material (£2.50q) 50 000 45 000 Wages and salaries (£5 500+£0.25q) Utilities (£2 500 + £0.05q) Facility rent 10 500 10 000 3 500 3 400 5 000 5 500 Insurance 2 800 3 200 Fuel 2 500 2 800 Net Operating Income £25 700 £20 100 Required: a) Outline the objectives of budgeting and explain how London Docks Café benefits from engaging in robust budgetary processes? b) Prepare a report showing London Docks Cafe's revenue and spending variance for December? c) Based on the variances report you prepared in (b) above, which area/s of activity should be of concern to the management of London Docks Café? Explain d) Explain the terms profitability and sustainability. Assess and advise the London Docks Café on the measures they should adopt to ensure the attainment of both mandates.

Planning and actual budgets for the month ended December 31st, 2020 PLANNING ACTUAL Budgeted meals quantity (q) 20 000 18 000 Revenues (£5.00q) £100 000 £90 000 Expenses: Raw material (£2.50q) 50 000 45 000 Wages and salaries (£5 500+£0.25q) Utilities (£2 500 + £0.05q) Facility rent 10 500 10 000 3 500 3 400 5 000 5 500 Insurance 2 800 3 200 Fuel 2 500 2 800 Net Operating Income £25 700 £20 100 Required: a) Outline the objectives of budgeting and explain how London Docks Café benefits from engaging in robust budgetary processes? b) Prepare a report showing London Docks Cafe's revenue and spending variance for December? c) Based on the variances report you prepared in (b) above, which area/s of activity should be of concern to the management of London Docks Café? Explain d) Explain the terms profitability and sustainability. Assess and advise the London Docks Café on the measures they should adopt to ensure the attainment of both mandates.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Current Attempt in Progress Monty Company combines its operating expenses for budget purposes in a selling and administrative expense budget For the first quarter of 2022, the following data are developed L Sales: 21,500 units unit selling price 2 Variable costs per sales dollar Sales commissions Delivery expense 3 Advertising Fixed costs per quarter Sales salaries Office salaries Depreciation Insurance Utilities $30 Save for Later 6% 4% $24,400 19,500 5,000 2,100 1,000 Prepare a selling and administrative expense budget for the first quarter of 2022 (List variable costs before fixed costs) MONTYCOMPANY Selling and Administrative Expense Budget
11. Calculating the Cash Budget Here are some important figures from the budget of Crenshaw, Inc., for the second quarter of 2019. LO 3 April May June $598,000 282,000 $689,000 $751,000 Credit sales 302,000 338,000 Credit purchases Cash disbursements 137,000 129,000 179,000 Wages, taxes, and expenses 15,600 15,600 15,600 Interest 53,500 6,600 248,000 Equipment purchases The company predicts that 5 percent of its credit sales will never be collected 35 percent of its sales will be collected in the month of the sale, and the re- maining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were $561,000. Using this information, com- plete the following cash budget: April May June $182,000 Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases 289,000 Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements…
Domino Consulting, budgeted overhead and other expenses as follows for the year ended December 31, 2023: Overhead: Rent $ 25,000 Repairs 10,000 Fuel 35,000 Maintenance 15,750 Supplies 6,100 Heat and light 20,250 Depreciation-computer 9,400 Miscellaneous 6,000 Depreciation-building 18,000 Depreciation-equipment…
K2 Inc. have the following budgeted business transactions for the month of May: Insurance refund to be received £500 Payments to be made to materials suppliers Payments to be made to employees Cash expected from customers £15,000 £4,000 £25,000 Budgeted depreciation charges £800 Interest to be paid to the bank £40 Budgeted personal drawings £2,000 K2 Inc. are budgeting an overdraft at the bank of £4,000 on the 1st May. What is K2 Inc.'s budgeted cash position at the end of May? O £460 cash in the bank O £460 overdrawn O £340 cash in the bank O £340 overdrawn
Graded HW i Fixed Budget For Year Ended December 31 $ Sales 3,171,000 Costs Direct materials 996,600 Direct labor 226,500 Sales staff commissions 60,400 Depreciation-Machinery 295,000 Supervisory salaries 203,000 Shipping 226,500 Sales staff salaries (fixed annual 250,000 amount) Administrative salaries 556,450 Depreciation-Office equipment 198,000 Income $ 158,550 Saved Required: 1&2. Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,100 units. Prepare a simple budgeted income statement if 18,100 units are sold. Complete this question by entering your answers in the tabs below. Req 1 Req 3 and 2 Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. Sales Variable costs Direct materials Direct labor Sales staff commissions Shipping Total variable costs Contribution margin Fixed costs PHOENIX COMPANY Flexible Budgets For Year Ended December 31 Flexible…
Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 560 sun shades in May and 350 in June. Each shade sells for $142. Shadee's beginning and ending finished goods inventories for May are 70 and 50 shades, respectively. Ending finished goods inventory for June will be 55 shades. E8-10 (Algo) Preparing Budgeted Income Statement [LO 8-3h] Each shade requires a total of $50.00 in direct materials that includes 4 adjustable poles that cost $5.00 each. Shadee expects to have 120 in direct materials inventory on May 1, 100 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $13 per hour. Additionally, Shadee's fixed manufacturing overhead is $10,000 per month, and variable manufacturing overhead is $15 per unit produced. Additional information: . Selling costs are expected to be 10…
Budgeted Selling and Administrative Expenses Salary Expense Sales Commissions 5% of Sales Insurance Expense Rent Depreciation on equipment Utilities Total Operating Expenses Schedule of Cash Payments for Selling and Administrative Expenses Salary Expense 100% of Prior Month Sales Commissions Insurance Expense October November December Multiple Choice 30,000 30,500 15,000 15,500 12,000 12,000 14,400 14,400 16,500 16,500 2,100 2,300 90,000 91, 200 ? 15,100 12,000 ? 2,200 ? 30,500 ? 12,000 ? ? ? Rent 100% of Prior Months Utilities Expense Total Payments for Selling and Administrative Expenses The amount of cash paid for Selling and Administrative expenses during the month of November is: 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ?
Q3: Flexible budget for a product as prepare by Anchor Ltd, is given below: Sales – unit 10,000 15,000 20,000 Rs. Rs. Rs. Sales 800,000 1,200,000 1,600,000 Manufacturing cost: Variable 300,000 450,000 600,000 Fixed 200,000 200,000 200,000 Total manufacturing cost 500,000 650,000 800,000 Marketing and other expenses: Variable 200,000 300,000 400,000 Fixed 160,000 160,000 160,000 Total Marketing and other exp 360,000 460,000 560,000 Operating…
Month ($) Wages ($) From the following information, prepare a monthly cash budget for the three months ending 31st December 2019. Sales ($) Materials Other Expenses ($) Jun. (A) 3,000 1,800 650 385 Jul. (A) 3,250 2,000 750 385 Aug. (A) 3,500 2,400 750 425 Sep.(A) 3,750 2,250 .750 475 Oct. (E) 4,000 2,300 800 500 Nov. (E) 4,250 2,500 900 550 Dec. (E) 4,500 2,600 1,000 575 (A) Actual; (E) - Estimated. = The credit terms are as follows: • Sales -10% of sales are in cash. On average, 50% of credit sales are paid in the next month, while the other 50% are paid two months after the sale. • Creditors for material are paid 2 months after purchase. • Wages and other expenses are paid the same month. The cash and bank balance on 1st October is expected to be $1,500. Other information is given as follows: • Plant and machinery are to be installed in August at a cost of $24,000. This sum will be paid in monthly installments of $500 each from 1st October. • Dividends from investments amounting to…
Ma 1 Prepare a PLANNED BUDGET for the month of December 2022 for your imaginary company assuming any level of activity. Prepare a SUMMARY OF ACTUAL RESULTS for the month of December 2022 for your imaginary company assuming any level of activity different from planned level of activity. That means, if you prepare a planned budget for 1000 units, your actual results should be for more than or less than 1000 units. Prepare a FLEXIBLE BUDGET for the actual level of activity for the month of December 2022 for your imaginary company. Prepare a PERFORMANCE REPORT (by comparing actual results with flexible budget) and shows therein REVENUE AND SPENDING VARIANCES.
Assume that a company provided the following cost formulas for three of its expenses (where q refers to the number of hours worked): Rent (fixed) Supplies (variable) Utilities (mixed) $ 4.009 $150 + $0.75q The company's planned level of activity was 2,110 hours and its actual level of activity was 1,850 hours. How much supplies expense would be included in the planning budget? Multiple Choice C $7,840 $8,140 $8,340 $ 3,000 $8,440
Management Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.