FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Aggrava
Limited is currently preparing budgets for September to December. Its estimated sales figures in units are as follows:
|
September
|
October
|
November
|
December
|
Sales (units)
|
13,794
|
6,713
|
3,381
|
19,210
|
Inventories at 31 August totalled
15,378
units, and inventories are to be kept at a constant level for all months except December, when opening inventories on 1 December are to be increased to
21,639.
Inventories will revert to the normal level on 31 December.Inventories will cost
£4
per unit until the end of October, when the price will increase to
£6
per unit, and suppliers allow
Aggrava
Ltd to pay in the month following an order. Other relevant information is that
6,710
units were bought in August.
Requirement 1:
|
Prepare
Aggrava
Ltd's inventories budget (in units) for September to December. |
Requirement 2:
|
Prepare the information relevant to inventories purchases that would appear in the
|
Requirement 3:
|
State the value of trade payables that would appear in the budgeted
|
Requirement 1:
Aggrava
Ltd's sales budget (in units) is as follows:(Fill in the relevant cells with its corresponding figures.)
|
September
|
October
|
November
|
December
|
Opening inventories (A)
|
|
|
|
|
Sales
|
|
|
|
|
A - B = (C)
|
|
|
|
|
Inventories purchase* (E - C)
|
|
|
|
|
Closing inventories (E)
|
|
|
|
|
* same as 'sales forecast' for each month except November and December, when inventories increase and then revert to normal.
Requirement 2: Relevant information for the cash budget is as follows:
(Fill in the relevant cells with its corresponding figures.)
|
August
|
September
|
October
|
November
|
December
|
Inventories purchased (units) (A)
|
|
13,794
|
6,713
|
9,642
|
12,949
|
Cost per unit (£) (B)
|
4
|
4
|
4
|
6
|
6
|
Cost of inventories bought [A*B = (C)]
|
|
|
|
|
|
|
|
|
|
|
|
Requirement 3:
The value of trade payables that would appear in the budgeted statement of financial position as at 31 December is
(Type an integer.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
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.Similar questions
- The Company has budgeted unit sales for the next four months as follows: October 4,800 units November 5,800 units December 6,400 units January 5,200 units The ending inventory for each month should be equal to 15% of the next month's sales in units. The inventory on September 30 was below this level and contained only 600 units. What are the total units to be produced in October?arrow_forwardFrolic Corporation has budgeted sales and production over the next quarter as follows: July August September Sales in units 70,000 83,000? question mark Production in units 73,250 84, 750 91,750 The company has 17,500 units of product on hand at July 1. 25% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 97,000 units. Budgeted sales for September would be (in units):arrow_forwardOsprey Cycles, Inc. projected sales of 60,589 bicycles for the year. The estimated January 1 inventory is 6,049 units, and the desired December 31 inventory is 7,919 units. What is the budgeted production (in units) for the year?__________________arrow_forward
- FRANCORP is preparing budgets for the quarter ending March 31. Budgeted sales for the next 5 months are as follows: January February March 16250 units 16950 units 17200 units 18350 units 17900 units April May The selling price per unit is $15. Determine the total budgeted sales for the entire quarter ending March 31st. O $756,000 O $815,000 O $850,350 O $750,550arrow_forwardYou are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 100 units February, 95 units March, 102 units April, 107 units May, 114 units June, 122 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 90 units March, 102 units April, 102 units May, 104 units June, 117 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 97 units April, 102 units May, 99 units June, 117 units In March of the current year, sales for the months April through June were reforecasted as follows: April, 102 units May, 94 units June, 107 units In April of the current year, sales for the months May and June were reforecasted as follows: May, 84 units June, 102 units In May of the current year, sales for June were…arrow_forwardDown Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 86,000 May 90,000 June 126,000 July 98,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 10% of the following month’s unit sales. The inventory at the end of March was 8,600 units. Required: Prepare a production budget by month and in total, for the second quarter.arrow_forward
- Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 153 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units. April 510 Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sales Budgeted beginning inventory units Total required units Units to produce May 590 RUIZ COMPANY Production Budget April June 540 590 30% July 630 May 540 30% June 630 30%arrow_forwardOsprey Cycles, Inc. projected sales of 64,237 bicycles for the year. The estimated January 1 inventory is 3,510 units, and the desired December 31 inventory is 6,177 units. What is the budgeted production (in units) for the year?______________________arrow_forwardABC Company’s budgeted sales for June, July, and August are 12,800, 16,800, and 14,800 units, respectively. ABC requires 30% of the next month’s budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 3,840 units. Required: Calculate the number of units to be produced in June and July.arrow_forward
- Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units, respectively, and the unit selling price is $43? b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory is 3,000 units, how many units should be produced? c. What dollar amount of material should be purchased at $4 per pound if each unit of product requires 3 pounds and beginning and ending materials inventories should be 5,000 and 4,000 pounds, respectively? d. How much direct labor cost should be incurred if each unit produced requires 1.5 hours at an hourly rate of $14? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $52,000 and variable manufacturing overhead is $2.50 per…arrow_forwardPerez Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Perez has budgeted sales as indicated in the following table. The company expects a 12 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Perez will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Round intermediate calculations and final answers to 2 decimal places.) Sales January February March $ 46,000 116,000 Cash sales Sales on account Total budgeted sales $ 162,000arrow_forwardIvanhoe Design provided the following budgeted information for April through July: April May June July Projected sales $112320 $132840 $124200 $142560 Projected merchandise purchases $88560 $99360 $84240 $71280 The cash balance on June 1 is $12960. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $33480 per month of which depreciation is $3240 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $4320 per month of which $648 is interest and the remainder is principal. How much are budgeted cash disbursements for June? $111024. $127872. $93312. $68256.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education