Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show formulas used. Thank you. Part B. Preparation of sales and puchase budget: You are in the process of preparing budget for 2020 for
Please show formulas used. Thank you.
Part B. Preparation of sales and puchase budget: You are in the process of preparing budget for 2020 for El Paso Division. - Based on the forecasts of the Sales Department, the sales are expected to increase by 10 per cent in each quarter. - According to the company's policy, the desired ending inventory is expected to be 20 per cent of the budgeted sales of the current quarter. - Ending inventory at the end of the Fourth quarter of 2019 is 2,500 units. 1. Complete Budget assumption box in the Data file Budget. (See the comments.) 2. Prepare a Sales budget and Purchase budget for El Paso Division (Use appropriate formula. Use Roundup function to calculate the number of units as a full unit in each row of the budget tables) Check figures: (Total budget sales: 102,102 units) (Total budgeted purchase: 105,459 units) 20,000 10% Budget Assumptions for El Paso Division Projected/Budgeted sales in unit for the Fourth Quarter of 2019 The percentage of sales increase from one quarter to next quarter Desired Ending Inventory at the end of each quarter is 20% of the Budgeted sales unit of the same quarter Budgeted Ending inventory units for the Fourth quarter of 2019 20% 2,500 Sales Budget for the 2020 1st quarter 2nd quarter 3rd quarter 4th quarter Total sale units Sales unit Answer check Purchase Budget for the 2020 1st quarter 2nd quarter 3rd quarter 4th quarter T otal sales Budgeted Sales unit Plus Desired Ending Inventory Equal to Total need Less Beginning inventory Equal to Budgeted Purchase Answer check
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started