Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need proper solution in excel The following information has been gathered to assit you in preparing the master budget for Fore Manufacturing Limited: 1.

image text in transcribed

I need proper solution in excel

The following information has been gathered to assit you in preparing the master budget for Fore Manufacturing Limited: 1. Budgeted sales for the next four months are as follows: July 20,000 August 30,000 September 22,000 October 21,000 The selling price is $50.00 per unit. Sales are 75% on credit & 25% cash. Of the credit sales 60% are collected in month of sale & 40% are collected in subsequent month. 2. The accounts receivable at June 30, 2021 of $417,870 will be collected in July. 3. The company produces enough units each month to meet the months sales plus a desired ending inventory equal to 20% of the next month's estimated sales. 4. Fore pays 40% of direct materials in the month of purchase & pays the remaining 60% in the following month. Each unit of product requires 8 kg of direct materials at a cost of $1.25 per kg. The company purchases enough direct materials each month for the current month's production and 15% of next month's production requirements. Beginning & ending inventory for the quarter of direct materials are budgeted to be 33,000 for beginning & 20,000 for ending. 5. The Accounts payable balance at June 30 of $146,200 will be paid in July. 6. The company plans to pays dividends of $10,000 in July & September. 7. Fore plans to purchase equipment for $15,000 in August & $25,000 in September. 8. Each unit produced requires 1 hours of direct labour at a cost of $20/hour. 9. The company wishes to maintain a minimum cash balance of $20,000 at the end of each month. 10. The company has an agreement with the local bank that allows them to borrow up to $100,000. The interest rate on the loans is 6% and there are no loans outstanding at June 30. All borrowing is done at the start of the month and all repayments are made at the end of the month. 11. The cash balance at June 30, 2021 is budgeted to be $21,000. Required: Using the excel file included in the assignment complete the following budgets for the third quarter of 2021 for Fore Manufacturing Limited (July, August, September). Sales Budget & Schedule of Expected Cash Collections Production Budget Direct Materials - Purchases & Cash Disbursements Budget Direct Labour Budget Cash Budget

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

Authors: Michelle Hanlon, Robert Magee, Glenn Pfeiffer, Thomas Dyckman

5th Edition

1618531654, 9781618531650

More Books

Students also viewed these Accounting questions

Question

Evaluate the following, accurate to the nearest cent.

Answered: 1 week ago

Question

What is management growth? What are its factors

Answered: 1 week ago

Question

=+What is the brand's character or personality?

Answered: 1 week ago