Aggrava Limited is currently preparing budgets for September to December. Its estimated sales figures in units are as​ follows:   ​(financial​ information) =          September October November December Sales (units) 5,569 14,234 14,847 15,121           Inventories at 31 August totalled 16,234 ​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 23,118. Inventories will revert to the normal level on 31 December. Inventories will cost​ £2 per unit throughout the​ period, and suppliers allow Aggrava Ltd to pay in the month following an order. Other relevant information is that 3,497 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 cash budget for the period.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 6PA: Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of...
icon
Related questions
icon
Concept explainers
Question
Aggrava Limited is currently preparing budgets for September to December. Its estimated sales figures in units are as​ follows:
 
​(financial​ information) = 
 
 
 
  September October November December
Sales (units) 5,569 14,234 14,847 15,121
 
 
 
 
 
Inventories at 31 August totalled
16,234
​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
23,118.
Inventories will revert to the normal level on 31 December.
Inventories will cost​ £2 per unit throughout the​ period, and suppliers allow
Aggrava
Ltd to pay in the month following an order. Other relevant information is that
3,497
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 cash budget for the period.
 
 
 

Question content area bottom

Part 1
Requirement​ 1:
Aggrava
​Ltd's inventories budget​ (in units) is as​ follows:
​(Fill in the relevant cells with its corresponding figures. Negative figures should be entered in​ brackets.)
 
 
September
October
November
December
Opening inventories (A)
 
 
 
 
Sales forecast (B)
 
 
 
 
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.
Part 2
Requirement​ 2: Relevant information relating to inventories purchases 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)
 
 
 
 
 
Cost per unit (£) (B)
2
2
2
2
2
Cost of inventories bought (£) [A*B = (C)]
 
 
 
 
 
Cash outflow (£)
 
 
 
 
 
Expert Solution
steps

Step by step

Solved in 3 steps with 2 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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT