Reference no: EM133022193
Question - A company is preparing budgets for a three-month period (November to January). Details include:
(i) Sales:
November RM115,200
December RM180,600
January RM108,900
10% of sales are for cash. 70% of the value of credit sales are payable in the month following sale, with the balance one month later.
(ii) Gross profit:
Product are bought-in and have a gross profit margin of 30% of sales. Products are purchased in the month before expected sale, payable 60% in the month following purchase with the balance one month later.
(iii) Overheads:
Variable overheads are 6% of sale value. Fixed overheads, including depreciation of RM9,100, are RM26,400 per month. All overheads, excluding depreciation, are paid for in the month incurred.
(iv) Capital expenditure:
Investment of RM44,000 in fixed assets will be paid for in January. The following information relates to the three-month period just ended:
(i) Sales:
August RM176,700
September RM153,000
October RM120,200
(ii) Products were purchased in the month before sale.
(iii) The cash balance at the end of October was RM4,640.
Required -
(a) Prepare a cash budget for each month (November, December and January).
(b) Calculate:
(i) Calculate the value of stock at the end of October.
(ii) Calculate the budgeted value of payables at the end of December.
(iii) Calculate the budgeted value of receivables at the end of January.
|
What is the firm marginal cost of capital
: Currently, the firm's capital structure has $250 million of debt, $55 million of preferred stock, What is the firm's marginal cost of capital
|
|
What is the expected return
: The risk-free return is 3.4% and the market risk premium is 12.5%. What is the expected return for the following portfolio
|
|
Prepare the journal entries to record their issuance
: Prepare the journal entries to record their issuance by The Bradford Company on January 1, 2021, interest on June 30, 2021 and interest on December 31, 2021
|
|
How much does the insurance policy cost per month
: On July 1, 2020, the bakery purchased a one-year insurance policy for $12,000 cash. How much does the insurance policy cost per month
|
|
Calculate the value of stock at the end of october
: Variable overheads are 6% of sale value. Fixed overheads, including depreciation of RM9,100, are RM26,400 per month. Calculate the value of stock
|
|
How much money will be in the account in three years
: A couple deposits $367 per month into an account paying 3% compounded monthly. How much money will be in the account in three years
|
|
How much is in the account after four years
: If $500 is deposited each year in a savings account paying 5.5% per annum compounded continuously, how much is in the account after four years
|
|
How much is the net income
: The consignee returned 1 defective set of books to the consignor and paid freight of P300. How much is the net income related with the consignment sales
|
|
Prepare a statement of retained earnings for the year
: Operating loss on discontinued Sand Division up to point of sale in 2020 $11,000. Prepare a statement of retained earnings for the year ended December 31, 2020
|