Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Following the data for Altor Corporation, a manufacturer of professional basketball balls. 1. Sales for the first quarter of 2020 are expected to be 8,500

image text in transcribed
Following the data for Altor Corporation, a manufacturer of professional basketball balls. 1. Sales for the first quarter of 2020 are expected to be 8,500 units. For the second quarter the company expect to have an increase of 30% of the previous quarter units sold. For the third quarter the company expects an increase of 20% of the second quarter units sold. For the forth quarter the company expects an increase of 40% of the third quarter units sold. The sale price is $90 per unit. Prepare a sales budget for the year. 2. Altor believes it can meet future sales needs with an ending inventory of 15% of next quarter's budgeted sales volume. Fourth Quarter 2019 on hand Inventory was 1,275 units. First Quarter 2021 projected sales are 22,300 units. Prepare a production budget for the year. 3. Altor maintains an ending Inventory or raw material equal to 20% of the next quarter's production requirements. The manufacture of each product requires 1.5 yards of leather material with an expected cost of the leather at $6 per yard. Assume that you would like to have 4.230 yard of leather as your desire ending direct material inventory for the fourth quarter of 2020. Inventory on hand as of first quarter 2020 was 1.760 yards of leather. Prepare a direct material budget for the year. 4. it takes 1.5 hours of direct labor to produce each unit of finished goods. The projected hourly rate for the floor employees for 2020 is $12 per hour. Prepare a direct labor budget for the year. 5. Altor Corporation expects variable costs to fluctuate with the production volume per quarter indirect materials $0.95 per production unit, indirect labor $1.90 per production unit utilities $0.80 per production unit, and maintenance $1.10 per production unit. Fixed cost for the company includes supervisor salaries per quarter, 518,000; depreciation of equipment per quarter, 53,500, equipment rent per quarter, 56,300; Insurance per quarter, 52,700, Maintenance per quarter, 54,100. Prepare a manufacturing overhead budget for the year. 6. Variable expense rates per unit of sales are sales commissions $2.50 and freight-out 51.25. Quarterly Fixed selling and administrative expenses include: advertising - $3.300; sales salaries - $12,350; office salaries $7,975, equipment depreciation - $880; insurance - 5960. Prepare a selling and administrative expense budget for the year. 7. The January 1, 2020, cash balance is expected to be 357.800. For the company sales, cash is collected at 709 in the quarter sold and 28 is collected in the following quarter. Accounts receivable of 589,000 at December 31, 2019, is expected to be collected in full in the first quarter of 2020. The company are expected to sell some excess old finished goods and raw material inventory for $28,000 cash in the first quarter of 2020. Direct materials are paid to in the quarter purchased and 40% are paid in the following quarter. Accounts payable of $37,600 as of at December 31, 2019, is expected to be paid in full in the first quarter of 2020. Direct laboris paid 100 in the quarter incurred. Manufacturing overhead and selling and administrative expenses are all paid in the quarter incurred except depreciation that is not included in the cash distribution Management plans to purchase new office equipment in the third quarter with a cout of 543,200 cash. Aitor makes zqualquarterly payments of dividends of $25,000. Prepare a schedule of collections from customers for the year

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

Step: 3

blur-text-image

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

Pioneers Of A Profession Chartered Accountants To 1879

Authors: Jas. C. Stewart

1st Edition

0367532557, 9780367532550

More Books

Students also viewed these Accounting questions

Question

Summarize the goal of humanistic psychotherapy.

Answered: 1 week ago