Selling price Materials cost GH¢20 per unit 3 kg per unit at GH¢2.5 per kg 0.6 hours per unit at GH¢4 GH¢1.2 per unit Labor cost Direct expenses Sales in May, June and July, 2021 are forecast to be 12,000 units in cach of the three months. As a direct result of marketing expenditure of GH¢8,000 in August 2021, sales are expected to be 11,000 units in August 2021, and to increase by 10% in cach 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 cach 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. 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 GHe 34,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 GH¢6,000 in cach of the two months. The cash balance at the end of June 2021 is expected to be GH¢60,000. Required: Prepare, on a month-by-month basis for the six-month period from July to December 2021, the following budgets: Sales budget Production budget Raw materials budget i. i. ii.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Selling price
Materials cost
GH¢20 per unit
3 kg per unit at GH¢2.5 per kg
0.6 hours per unit at GH¢4
GH¢1.2 per unit
Labor cost
Direct expenses
Sales in May, June and July, 2021 are forecast to be 12,000 units in cach of the three months.
As a direct result of marketing expenditure of GH¢8,000 in August 2021, sales are expected
to be 11,000 units in August 2021, and to increase by 10% in cach month from September to
December, 2021. Sales after December 202i 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 cach 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.
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 GH¢34,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 GH¢6,000 in each of the two months.
The cash balance at the end of June 2021 is expected to be GH¢60,000.
Required:
Prepare, on a month-by-month basis for the six-month period from July to December 2021,
the following budgets:
Sales budget
Production budget
Raw materials budget
Direct expenses budget
Overhead budget
i.
ii.
iii.
iv.
V.
vi.
Budgeted income statement
vii.
Cash budget
Transcribed Image Text:Selling price Materials cost GH¢20 per unit 3 kg per unit at GH¢2.5 per kg 0.6 hours per unit at GH¢4 GH¢1.2 per unit Labor cost Direct expenses Sales in May, June and July, 2021 are forecast to be 12,000 units in cach of the three months. As a direct result of marketing expenditure of GH¢8,000 in August 2021, sales are expected to be 11,000 units in August 2021, and to increase by 10% in cach month from September to December, 2021. Sales after December 202i 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 cach 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. 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 GH¢34,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 GH¢6,000 in each of the two months. The cash balance at the end of June 2021 is expected to be GH¢60,000. Required: Prepare, on a month-by-month basis for the six-month period from July to December 2021, the following budgets: Sales budget Production budget Raw materials budget Direct expenses budget Overhead budget i. ii. iii. iv. V. vi. Budgeted income statement vii. Cash budget
Expert Solution
steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education