Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sleepright manufactures wooden bedframes. Each unit sells for 150. Demand for the coming months is expected to be as follows: July: 2,000 units August: 3,000

Sleepright manufactures wooden bedframes.

Each unit sells for 150. Demand for the coming months is expected to be as follows:

July: 2,000 units

August: 3,000 units

September: 5,000 units

October: 6,000 units

All bedframes are sold to customers on the following terms: 10% payable in month of sale and 90% in the month following sale.

The closing bank balance on 30th June will be 240,000.

Production details are as follows:

  • - The company maintains an inventory of finished goods equal to half of the following months projected sales.

  • - Each unit requires 10 metres of oak costing 6 per metre. Suppliers are paid in the month following purchase. Supplies of oak are held in quantities equal to amounts required for the following month's production requirements. The value of oak purchased in June is 150,000.

  • - Labour costs are budgeted to be 75,000 in July and 120,000 in August.

  • - Fixed costs are estimated to be 10,000 per month inclusive of depreciation of 2,000 each month.

Complete the company's production budget for July and August:

NB: All figures in this table should be written as positive whole numbers (e.g 1,000 or 1000).

In Units July August

Sales

Closing inventory
Opening inventory
Production required

Complete the Raw Materials Budget:

NB: All figures in this table should be written as positive whole numbers (e.g 1,000 or 1000).

July August
Raw materials required for production
Closing inventory
Opening inventory
Raw material required
Price per unit 6

value of raw materials purchases

Raw materials payments 150,000

Complete the cash budget for July and August

NB: All figures in this table should be written as positive whole numbers (e.g 1,000 or 1000), with the exception of a net cash outflow which should be written as a negative figure, e.g -10,000

July August
Cash inflows:Sales receipts
Cash outflows:
Purchases
Labour
Fixed costs
Net cash inflows/(outflows)
Opening balance
Closing balance

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 For Decision Makers

Authors: Mark DeFond

2nd Edition

1618533142, 9781618533142

More Books

Students also viewed these Accounting questions

Question

LO35.3 Describe how a bank can create money.

Answered: 1 week ago