Cash budget on a monthly basis

Assignment Help Managerial Accounting
Reference no: EM133083318

BAF2202 Management Accounting

QUESTION 1

The following information has been assembled by Sancross Products Ltd which manufactures and retails products A and B. The details given below relate to the year commencing 1 July 2000:

Standard Product
Price per kg A kg g
Direct material - M1 Sh 4 15 20
M2 Sh 5 14 12

Standard Product
Rate per hourA hours B hours
Direct labour - L1 Sh 8 20 15
L2 Sh10 22 24
Fixed production overhead is applied on direct labour basis. Administration, selling and distribution expenses are recovered at the rate of 20% of production cost and profit loaded at 25% of standard production cost.

Product
A B
Sh ‘000'Sh ‘000'
Projected sales for the year 12,033 10,053
Finished goods stock position valued at production cost is expected to be as follows:

Product
A B
Sh ‘000' Sh ‘000'
1 July 2000 3,000 2,000
30 June 2001 5,000 4,000

Direct material stocks valued at standard prices are as follows:

Material
M1 M2
Sh ‘000' Sh ‘000'
1 July 2000 200 250
30 June 2001 220 270
For the year to 30 June 2001, fixed production overhead has been estimated at
Sh 1,800,000 and direct labour at 1,200,000 hours.
No opening or closing work-in-progress is anticipated.

Required:
a) Production budget in units.
b) Direct materials cost budget.
c) Purchases budget in value.
d) Direct labour cost budget.

QUESTION 2
You are in charge of making forecasts and preparing budgets. You have been supplied with cost and revenue forecasts and details of payment as follows:
1. Forecast of revenue and costs for the quarter ending 31 March 2001
January February March
Shs. Shs. Shs.
Direct
Materials (purchases) 112,000 100,000 135,000
Wages 90,000 80,000 100,000
Overhead
Production 34,000 32,000 40,000
Administration 22,000 20,000 27,000
Selling and distribution 13,000 11,000 18,000
Sales 360,000 350,000 440,000

2. Forecast of revenue and costs for the quarter ending 30 June 2001
April May June
Sh. Sh. Sh.
Direct
Materials (purchases) 90,000 67,000 79,000
Wages 72,000 54,000 63,000
Overhead
Production 45,00036,000 40,000
Administration 22,000 25,000 27,000
Selling and distribution 13,000 11,000 16,000
Sales 350,000 360,000 360,000
Cash balance on 1 April 2001 Sh. 90,000

Other details
• Period of credit allowed by suppliers averages two months.
• Debenture to the value of Shs. 125,000 are being issued in May 2001 and the amount is expected to be received during the month.
• A new machine is being installed at the end of March 2001 at a cost of Sh 150,000 and payment is promised in early May 2001.
• Sales commission of 3% is payable within one month of sales.
• A dividend of Sh 100,000 is to be paid in June 2001.
• There is a delay of one month in the payment of overheads. There is also a delay in payment of wages averaging a quarter of a month.
• Twenty per cent of the debtors pay cash, receiving a cash discount of 4% and 70% of debtors pay within one month and receive a cash discount of 2 ½%. The other debtors pay within two months.

Required:
A cash budget on a monthly basis from the second quarter of the year 2001.

Attachment:- Management Accounting.rar

Reference no: EM133083318

Questions Cloud

Develop three forms of work breakdown structure : Develop three (3) forms of work breakdown structure. For each diagram, provide a brief summary.
Explain the firm accounting profit : Defne used to earn an annual income of $35, 000 as logistic Manager while Yasmien left her salary of $ 20,000 as a designer for Passionist?
Determine the amount of the income subsidy : Assume that actual earnings are subtracted from the guaranteed income level to determine the amount of the income subsidy.
What is the after tax rate of return : What is the after tax rate of return if the perpetuity is sold at time t+1 when the market interest rate continues to be equal to 5%?
Cash budget on a monthly basis : A cash budget on a monthly basis from the second quarter of the year 2001 - distribution expenses are recovered at the rate of 20% of production cost
The nonequivalence of high school equivalents : Analysis of the article "The Nonequivalence of High School Equivalents" by Cameron and Heckman for an Empirical Evidence presentation.
What are the risk-adjusted on-balance-sheet assets : a. What are the risk-adjusted on-balance-sheet assets of the bank as defined under the Basle Accord?
How real gdp and potential gdp grow over time : How Real GDP and Potential GDP grow over time?
What is fixed cost in particular example : Assume the following short-run cost function =100+10 +5 2.C=100+10Q+5Q2.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Calculate the contribution margin for each unit produced

Using cost behaviour breakdown, calculate the Contribution Margin for each unit produced. Calculate the Gross Profit Margin and Net Profit Margin Ratios

  What type of responsibility centre describes ally department

What type of responsibility centre best describes her department? Ally Jones, manager of the Vodafone sales team, has the budget for her department

  What level of inventory should the business reorder

The exercise bands are ordered from a supplier at a price of $39, At what level of inventory (in units) should the business reorder the exercise bands?

  What is the companys earnings per share for year two

What is the company's earnings per share for Year 2? What is the company's price-earnings ratio for Year 2? What is the company's dividend payout ratio for Year 2? What is the company's dividend yield ratio for Year 2?

  Prepare the journal entry to recognize the transfer

Prepare the journal entry to recognize the transfer of the units completed and transferred to finished goods during October.

  What effect would this have on the profitability

Annual fixed manufacturing cost is JOD 72,000. What effect would this have on the profitability of the special order

  Problem 1 - journal entries larney corporationlarney

problem 1 - journal entries larney corporationlarney corporation uses process costing. a number of transactions that

  Provide for a rule of thumb that johnson could apply

Provide for a "rule of thumb" that Johnson could apply to decide on these special-order offers. Please provide your calculations and reasoning.

  What is the value of closing inventory of finished goods

Find What is difference in profit between absorption and variable costing and, for this specific year for this company, which of the two stock-costing methods

  Determine the average rate of return on investment

Determine the average rate of return on investment, giving effect to depreciation on the investment. Round your answers to two decimal places

  Explain how the principles of management accounting utilized

Explain how the principles of management accounting can be utilized. What specific managerial accounting activities would be useful?

  What was the income from operations

If the contribution margin ratio for France Company is 45%, sales were $425,000, and the fixed costs were $100,000, what was the income from operations?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd