From the above given information, I am to construct a tabular form of cash budget, however, I don't really understand the question, so I think my answer is wrong, can you try it for me so I can check with my answer? Q1.Below are the budgeted revenue and expenses for a restaurant for the year 2022.RevenueRM (*000)71,250SalesRM (*000)28,5004,200ExpensesCost of suppliesSalaries17,100900WagesDepreciationRepair and MaintenanceAdvertisement|Laundry|Interest on LoanMiscellaneous expensesUtilities3,0001,5002002,2002,300650Below are the additional information given to you for further analysis:The expected pattern of sales for the year 2022 are as follows and it is thecompany policy to analyse based on quarters.Percentage of sales24202432Quarter23475% of the sales are on a cash basis and the balance will be received in thenext quarter.The costs of supplies vary directly with sales and a constant stock value ofsupplies are kept. 20% of purchases of the food and drinks are for cash and thebalance are paid during next quarter.80% of the repairs and maintenance item is for a major redecoration to be paidin the third quarter.Wages, which are variable with sales, are paid in the same quarter which theyare incurred.Utilities and interest on loan are paid half yearly in the first and third quarters. All other expense payments are made evenly over the year.Below are the opening balances:Items| Trade receivablesTrade payablesBank overdraftRM (*000)4,7507,050800Required:Prepare a tabular form of the cash budget for the four quarters of the year 2022.

Particulars Q1 Q2 Q3 Q4 Total Sales (a) 71,250 71,250 71,250 71,250 % of Sales pertaining to the…

Answered: Required: Prepare a tabular form of the…

Business

Accounting

Required: Prepare a tabular form of the cash budget for the four quarters of the year 2022.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter13: Budgeting And Standard Costs

Section: Chapter Questions

Problem 13.2.7P

See similar textbooks

Similar questions

3. What will be the budgeted ‘Salaries’ expenses for 2020 ($)? Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer. Type your answer as a whole number (e.g., 200000). • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area.
Given the information below, answer questions 1-3. • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area. 1. What will be the budgeted ‘Room Revenue (Sales)’ for 2020 ($)? Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer. Type your answer as a whole number (e.g., 200000).
Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: As Tune Printing Supply's controller, you have assembled the following additional information: a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,200 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 45% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April. h. April budgeted sales, $86,000, 50% collected in April and 50% in May. i. April…
Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: As Tune Printing Supply's controller, you have assembled the following additional information: a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,200 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 45% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April. h. April budgeted sales, $86,000, 50% collected in April and 50% in May. i. April…
ONLY ANSWER QUESTION (B) AS I HAVE ANSWER FOR (A) ALREADY SALLAT Household Furnishings & Appliances is a family-owned business. You are themanagement accountant of the entity and have been given the task of preparing the cash budgetfor the business for the quarter ending September 30, 2022. Your data collection has yielded thefollowing:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800…
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…
Tune Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: As Tune Printing Supply's controller, you have assembled the following additional information: a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,200 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 45% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April. h. April budgeted sales, $86,000, 50% collected in April and 50% in May. i. April cash payments of…
Q3: Fantastic Cement Manufacturing Company expects from you to calculate and present the master budget for the year 2020 from the following information? 1. Sales budget: Type 1 cement Br400, 000 Type 2 Cement Br600, 000 2. Production costs budget: Direct material cost 70% of sales Direct wages Br 50,000 3. Manufacturing overhead budget : Fixed manufacturing overhead Br 24,000 Variable manufacturing overhead Br 36,000 4. Total Operating expenses budget Br 30,000 Required: prepare a Master Budget for Fantastic Company for Year 2020 and show the expected net profit by considering the above data only
Prepare a Budgeted Statement of Financial Position as at 31 December 2022 using the below information: Statement of comprehensive income for the year ended 31 December 2021Sales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable selling and administrative expenses (1 500 000)Fixed selling and administrative expenses (500 000)Net profit 2 250 000 Statement of financial position as at 31 December 2021ASSETSNon-current assets 800 000Property, plant and equipment 800 000Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000 4 200…
2. What will be the budgeted ‘Guest Supplies’ expenses for 2020 ($)? • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area. Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer. Type your answer as a whole number (e.g., 200000).
The information provided below was taken from the records of Chotoo Projects for the financialyear ended 31 May 2020.Extract of statement of comprehensive income for the year ended 31 May 2020RRevenue 480 000Direct costs 240 000Rent income 150 000Advertising 4 800Salaries and wages 90 000Rates and taxes 1 200Other operating expenses 80 000Additional information1. Revenue is calculated as direct cost plus 25%.2. Revenue is divided equally each month. Revenue is expected to increase by 18% for thefinancial year ending 31 May 2021.POSTGRADUATE DIPLOMA IN PROJECT MANAGEMENT – ACADEMIC AND ASSESSMENT CALENDARREGENT BUSINESS SCHOOL (RBS) January 2021 173. Fifty percent (50%) of the revenue is for cash and the balance is on credit. Debtorsnormally pay their accounts as follows:• 40% in the month of the invoice, and these debtors are entitled toa 5% discount;• 55% one month after the invoice;The balance is usually written off as bad debts.4. Purchases for June and July are expected to be 30…
The following information pertains to Yoyo Projects for the three months ended 31 May 2020: Actual Budgeted March R April R May R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional Information: It is expected that debtors will settle their accounts as follows: 20 % in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of invoice The remaining 5% is usually written off as bad Trade creditors are paid in the month after purchase at a discount of 5%. 50% of the salaries and wages are weekly wages. Since wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were Expenses are paid as they The favourable…