Problem 1 The following data relate to Bookshop Ltd: The financial manager has made the following sales forecasts for the first five months of the coming year, commencing from 1 April 2012: Month Sales($) April May June July August Other data: (i) 40,000 45,000 55,000 60,000 50,000 Debtors' and creditors' balance at the beginning of the year are $30,000 and $14,000,. T balance of other relevant assets and liabilities are: Cash Balance Stock Accrued Sales Commission $7,500 $51,000 $3,500 40% sales are on cash basis. Credit sales are collected in the month following the sale. Cost of sales in 60 per cent on sales. (iv) The only other variable cost is a 5% commission to sales agents. The Sales Commission is paid a month after it is earned. respectively (iv) Inventory (stock) is kept equal to sales requirements for the next two month budgeted so Trade creditors are paid in the following month after purchases. (v) (vii) Fixed costs are $5,000 per month including $2,000 depreciation.

Problem 1 The following data relate to Bookshop Ltd: The financial manager has made the following sales forecasts for the first five months of the coming year, commencing from 1 April 2012: Month Sales($) April May June July August Other data: (i) 40,000 45,000 55,000 60,000 50,000 Debtors' and creditors' balance at the beginning of the year are $30,000 and $14,000,. T balance of other relevant assets and liabilities are: Cash Balance Stock Accrued Sales Commission $7,500 $51,000 $3,500 40% sales are on cash basis. Credit sales are collected in the month following the sale. Cost of sales in 60 per cent on sales. (iv) The only other variable cost is a 5% commission to sales agents. The Sales Commission is paid a month after it is earned. respectively (iv) Inventory (stock) is kept equal to sales requirements for the next two month budgeted so Trade creditors are paid in the following month after purchases. (v) (vii) Fixed costs are $5,000 per month including $2,000 depreciation.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 51E: Juroe Company provided the following income statement for last year: Juroes balance sheet as of...

See similar textbooks

Similar questions

Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
Assume that it is now July of Year 1 and that the brothers are developing projected financial statements for the following year. Further, assume that sales and collections in the first half-year matched the predicted levels. Use the Year-2 sales forecasts shown in the following table to estimate next year’s receivables levels for the end of March and for the end of June.
The sales data (in units) of book store has been extracted for the three terms over 3 years as follows; Term-1Term-2 Term-3 20204500 3,000 1,200 2021 6,000 4,200 2,400 20227,800 5,400 3,600 Required: Using multiplicative index, forecast sales for term-III (to the nearest 100) of the year 2023 given an annual sales forecast of 18,000 OA. 3,100 units B. 3,500 units OC. 3,300 units OD. 3,400 units
Bluewater, Inc. has the following estimated quarterly sales for next year. The accounts receivable period is 60 days. What is the expected accounts receivable balance to the nearest dollar at the end of the third quarter? Assume that each month has 30 days. Q2 Q3 Q4 $1,300 $1,425 $2,200 Ⓒa. $800 b. $367 c. $950 d. $733 Qe. $867 Q1 Sales $1,850
Projector Limited has the following projection for the 4 months ending August 2018:MayJuneJulyAugustR’sR’sR’sSales320 000380 000420 000460 000Purchases160 000160 000230 000250 000Rent income11 00011 000??Salaries26 80026 800??1. 50% of the sales are for cash and the balance is on credit.2. All credit sales are collected one month after the sale.3. All purchases are on credit. Creditors are paid in full one month after the month of purchase.4. The tenants rent contract stipulates an increase of 20% from 1 July 2018.5. Salaries are expected to increase to R32 000 per month as at 1 August 2018.6. A new motor vehicle will be purchased during June 2017. Repayments of R6 000 per month will commence on 1 July 2017.7. Advertising costs are expected to be 2% of sales from 1 June 2018.8. A fixed deposit of R25 000 will mature in the month of July 2018.9. On 31 May 2018, the bank is expected to have a favourable balance of R420 000.Required:Prepare a Cash Budget for the three (3) months ending…
Bluewater, Inc. has the following estimated quarterly sales for next year. The accounts receivable period is 60 days. What is the expected accounts receivable balance to the nearest dollar at the end of the third quarter? Assume that each month has 30 days. Q1 Q2 Q3 Q4 Sales $1,850 $1,625 $1,345 $1,200 Question 4 Answer a. $ 448 b. $ 897 c. $ 1,532 d. $ 673 e. $1,485
Please Format in tables Jamieson Ltd is preparing to set up business on 1/7/2022 and has made the following forecast for the first six months of trading: July August Sept Oct Nov Dec Total Sales $525,000 588,000 616,000 630,000 658,000 672,000 3,689,000 Purchases $300,000 336,000 352,000 360,000 376,000 384,000 2,108,000 The expected selling price is $70 per unit. The cash collection pattern from debtors is expected to be: Cash customers - 30% of sales revenue will be for immediate cash and cash discount of 5% will be allowed. Credit customers - 70% of sales revenue will be from credit customers. These creditors will pay their bills 50% in month after sale and the remainder in the second month after sale. The purchases will be paid for 50% in month after purchase when 2% cash discount will be received. The remaining purchases will be paid for in the second month after purchase. Expected costs:…
Roque Company has been accumulating operating data in order to prepare an annual profit plan. Details regarding Roque’s sales for the first 6 months of the coming year are as follows: Forecasted sales January P600,000; February P650,000; March P700,000; April P625,000; May P720,000; June P800,000 Types of sales Cash sales 20% Credit sales 80% Collection Pattern for Credit Sales Month of sale 30% One month following sale 40% Second month following sales 25% Roque’s cost of goods sold averages 40% of the sales value. Roque’s objective is to maintain a target inventory equal to 30% of the next month’s sales in units. Purchases of merchandise for resale are paid for in the month following the sale. The variable operating expenses (other tan cost of goods sold) for Roque are 10% of sales and are paid for in the month following the sale. The annual fixed operating expenses are presented below. All of these are incurred uniformly throughout the year and paid monthly except for…
Roque Company has been accumulating operating data in order to prepare an annual profit plan. Details regarding Roque’s sales for the first 6 months of the coming year are as follows: Forecasted sales January P600,000; February P650,000; March P700,000; April P625,000; May P720,000; June P800,000 Types of sales Cash sales 20% Credit sales 80% Collection Pattern for Credit Sales Month of sale 30% One month following sale 40% Second month following sales 25% Roque’s cost of goods sold averages 40% of the sales value. Roque’s objective is to maintain a target inventory equal to 30% of the next month’s sales in units. Purchases of merchandise for resale are paid for in the month following the sale. The variable operating expenses (other tan cost of goods sold) for Roque are 10% of sales and are paid for in the month following the sale. The annual fixed operating expenses are presented below. All of these are incurred uniformly throughout the year and paid monthly except for insurance and…
Question (1) SamZuu Company is location in Ghana. The forecast information for the five months ending 31 May 2013 is: February Ghc'000 March January Ghc'000 April Ghc'000 Мay June Ghc'000 Ghc'000 Sales 20 16 28 26 30 24 Purchases 12 16 18 14 12 15 Machinery Depreciation 5 Interest paid 4 40 50 4 3 1 1 4 3 3 Further Information: a) On average 30% of each month's sales is expected to be for cash. Further 50% will be given one month's credit. The rest will be given two months' credit. All money will be received when due. b) Suppliers are to allow one months credit. November & December 2012 purchases were Ghc 20,000 and Ghc 16,000 respectively c) Interest will be paid at the end of the month in which they are incurred and depreciation is accounted in their respective months d) 50% of Machinery sold in the month will be received in that month and the remaining amount spread evenly over the next 11months e) The overdraft facility 13/12/2012 was Ghc (3,400) Required: Prepare a detail forecast…