Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c) Comfort Ltd manufactures and sells a single product called Adepa. The business is preparing its semi-annual budget from July to December for the year

image text in transcribed

c) Comfort Ltd manufactures and sells a single product called Adepa. The business is preparing its semi-annual budget from July to December for the year 2021. The following standard revenue and cost data is available. Selling price Materials cost Labor cost Direct expenses GH20 per unit 3 kg per unit at GH2.5 per kg 0.6 hours per unit at GH4 GHe 1.2 per unit Sales in May, June and July, 2021 are forecast to be 12,000 units in each of the three months. As a direct result of marketing expenditure of GH8,000 in August 2021, sales are expected to be 11,000 units in August 2021, and to increase by 10% in each month from September to December, 2021. Sales after December 2021 are expected to remain at the December 2021 level. From business history, the management of Comfort Ltd has determined the following to be the pattern by which sales revenues are received: Twenty-five percent (25%) of sales are received in the month during which the sales occur; 30% of sales are received in one month following the month of sale; 30% of sales are received in two months following the month of sale; and 12% of sales are received in the third month following the month of sale. The remaining percentage of sales revenue is expected to be uncollectible. Inventories of finished goods at the end of each month are planned to be 20% of the expected sales for the following month. Inventories of materials at the end of each month are planned to be 50% of the material required for the following month's production. Inventory of finished goods at the close of June 2021 is expected to be 1.800 units, while inventory of raw materials at the close of June 2021 is expected to be 9,200 kg. 1 Materials are paid for in the month following purchase. Labor and direct expenses are paid for in the month in which they occur. Overheads for production, administration and distribution is expected to be GH34,000 per month, which amount includes a depreciation charge of GH 12,000 per month. These overheads are payable in the months in which they occur. The firm pays interest twice per year, in March and September at GH6,000 in each of the two months. The cash balance at the end of June 2021 is expected to be GH60,000. Required: Prepare, on a month-by-month basis for the six-month period from July to December 2021, the following budgets: i. Sales budget ii. Production budget Raw materials budget Direct expenses budget v. Overhead budget Budgeted income statement Cash budget 111. IV VI. vii

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_2

Step: 3

blur-text-image_3

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

Study Guide Working Papers For College Accounting, Chapters 1-9

Authors: James A. Heintz, Robert W. Parry

23rd Edition

0357474740, 9780357474747

More Books

Students also viewed these Accounting questions

Question

What are the major causes of stress on the job? Off the job?

Answered: 1 week ago

Question

provide a thorough insight into what job crafting really is;

Answered: 1 week ago