Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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: [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.(b) Schedule of cash collected from customers.(c) Production budget.(d) Direct-material usage and purchases budget.(e) Schedule of cash disbursement to suppliers for direct material.(f) Direct labour budget.(g) Production overhead budget.(h) Selling and administrative budget(i) Cash budget2. Prepare the following budgets in total only for the four months ending July 31, 2023:(a) Cost of goods sold budget.(b) Budgeted Statement of Profit or Loss.(c) Budgeted Statement of Financial Position.

image text in transcribed
[A] Projected Statement of Financial Position as at 31 March 2023: ASSETS Non current Assets Plant and equipment at cost 1,440,000 Less Accumulated depreciation 238 000 1,152,000 Raw materials 30.?50 Finished goods 38.750 Accounts Receivables 200,000 Cash m EQUITIES AND LIABILITIES Capital Shane capital 1,142,300 Accumulated profits {Retained Earnings) 500 000 1,247,300 Current Liabilities Accounts Payables m 1,975,750 [B] Sales and production data: Sweet Sales demand for finished goods: April 5000 units May ?,500 units June 12,500 units July 15,000 units August 12,000 units Sellingprice per unit 5200 Finished goods: Projected closing inventory at 31 March 2023 250 units Unit cost of finished goods inventory $155 per unit Variable production overhead direct labour hours required for production: Processing 12 mins Cost per hour for variable overhead $50 per hour Fixed production overhead per month including $45,000 depreciation of $8,000 Materiai requirement per unit: Raw material 0.40 lbs Direct labour hours required per unit 12 minutes Direct labour rate per hour $100 per hour [C] Raw materials Material Closing inventory in lbs at 31 March 2023 102.50 Closing inventory in lbs at 31 July 2023 597.50 Bud eted cost of raw material er lb $300 er lb Actual costs per pound of opening raw material inventories are as budgeted for the coming period. [D]The Company maintains a policyr of holding 5% of the next month's demand for "Sweet" in inventory. The policy [or 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]Sel|ing and Administrative expenses are expected to he: 0 Variable 2% of sales revenue - Fixed $100,000 [3\

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

Financial Accounting Plus

Authors: Robert Libby, Patricia Libby, Daniel Short

8th Edition

1259116832, 9781259116834

More Books

Students also viewed these Accounting questions