Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The approved 2020 Operating Budget for XYZ Ltd. Is provided below, along with actual results for the first quarter of the year provided to you
The approved 2020 Operating Budget for XYZ Ltd. Is provided below, along with actual results for the first quarter of the year provided to you by your accounting assistant. 2020 Budget Actual to March 31, 2020 Revenue $ Sales Rental income Grants and Donations User fees Miscellaneous 200,000 $ 20,000 10,000 50,000 5,000 45,000 6,000 3,000 20,000 2,000 Total revenue 285,000 76,000 Expenses Salaries Wages Benefits Materials Supplies Contracted services Utilities Insurance Rent Advertising Travel 145,000 18,000 15,000 25,000 5,000 10,000 4,800 4,000 10,000 12,000 4,000 50,000 2,000 3,000 8,000 1,500 4,000 1,200 1,000 3,000 8,000 2,000 Total expense 252,800 83,700 Surplus/deficit $ 32,200 (7,700) 1 e Allocate the annual budget, on a quarterly basis, over the year, given the information below: (a) Sales - 30% of sales occur in December. The balance of sales occur equally over the remaining 11 months (b) Rental income is earned equally over the year (c) 25% of grants and donations are received in March, June, Sept and Dec (d) User fees are earned in June and July - 25% in June and 75% in July (e) Miscellaneous revenue is earned completely in December (f) Salaries are paid equally over the year (g) Wages allow the company to hire 4 summer students over the months of May to August (an equal amount is spent each month during that period) (h) Benefits expense is 10.34% of monthly budgeted salaries Monthly materials expense in incurred in the same proportion as sales (see (a)] Contracted services are incurred equally in August and September (k) Utilities, rent and insurance expenses are incurred equally in each month (0) 50% of advertising expenses are incurred in Nov and Dec. The remaining 50% is spent equally over the balance of the year. (m) Travel expenses are incurred 50% in May and 50% in October (n) The years total supplies are purchased in January EEST= NOTE: Total budget allocations must agree with the total 2020 budget provided. Any required rounding should be done in the last quarter allocation. 2 Prepare a "Budget Variance Report" as of March 31, 2020. Provide possible explanations for any variances in excess of $5,000 as of March 31, 2020. 3 Prepare a "Cash Flow Budget", on a quarterly basis, given the following: (a) Assume actual revenues and expenditures for 2020 are the same as quarterly budget distributions developed in Part 1 of this question. (b) The company borrowed $48,000 in April, 2020 to be repaid monthly over the next year (starting in May, 2020). In addition to the principal repayment, $100 of interest will be paid each month (c) The company bank balance is $100,000 on January 1, 2020 (Hint : Cash Balance at December 31, 2020 $147,400) 4 The CFO has asked you for comments on the projected cash flow for 2020. What points would you bring to the CFO's attention
Step 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