Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing The Art And Science Of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Ingrid B. Splettstoesser-Hogeterp

11th Edition

0132088061, 978-0132088060

More Books

Students also viewed these Accounting questions

Question

=+ (a) What was the gain or loss on the sale?

Answered: 1 week ago

Question

Hagen 14

Answered: 1 week ago

Question

11.1 Explain the strategic importance of total rewards.

Answered: 1 week ago

Question

11.3 Define pay equity and explain its importance today.

Answered: 1 week ago