Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like to get assistance on the cash budget Actual costs per pound of opening raw material inventories are as budgeted for the coming

image text in transcribed

image text in transcribed

I would like to get assistance on the cash budget

Actual costs per pound of opening raw material inventories are as budgeted for the coming period. [D] The company maintains a policy of holding 5% of the next month's demand for "Sweet" in inventory. The policy for raw materials is to maintain 5% of next month's requirements in inventory. [E] Collection from customers is expected to be as follows: - 90% in the month in which the sales are made - 10% in the first month after the sale [F] 80% of all raw materials purchased are expected to be paid for in the month of purchase with the remaining amount being paid in the following month. [G]Selling and Administrative expenses are expected to be: - Variable 2% of sales revenue - Fixed $100,000 per month including $4,000 for depreciation. [H]Tax payable represents 25% of profit before tax and is paid on March 15 each year for profit made in the prior year. Profit before tax for the year ended December 31, 2022 was $600,000 Required: 1. Prepare the following budgets for Best Friends Pre-season Limited by month and in total for the four months ending July 31,2023 : (a) Sales budget. (6 marks) (b) Schedule of cash collected from customers. (10 marks) (c) Production budget. (17 marks) (d) Direct-material usage and purchases budget. (231/2 marks) (e) Schedule of cash disbursement to suppliers for direct material. (10 marks) (f) Direct labour budget. ( 91/2 marks) (g) Production overhead budget. (11 marks) (h) Selling and administrative budget (11 marks) (i) Cash budget (251/2 marks) 2. Prepare the following budgets in total only for the four months ending July 31, 2023: (a) Cost of goods sold budget. (8 marks) (b) Budgeted Statement of Profit or Loss. (5 marks) (c) Budgeted Statement of Financial Position. (1321 marks) [Total 150 marks] NOTE: Ensure your presentation has cell referencing and formulas. Marks are awarded for these. Big Boss Limited was formed two years ago by Joshua Sealers. He had the idea to make a product for Quick Service Restaurants that would be easy and convenient to prepare. He bought several used plant and equipment from a company that was involved in making a similar product but was leaving the industry. Big Boss estimated that the equipment would be able to last for 10 years once it was properly maintained. He called his finished product "Sweet". The budget for the next four months ending 31 July 2023 is to be prepared. The following data was gathered: [B] Sales and production data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions