Financial Analysis Problems and Solutions for Alpha Company

ACCT 221 Principles of Accounting

Answered

Task

1. Alpha manufactures chairs, and each requires 4 board feet of lumber. Alpha expects that 1,500 and 1,700 chairs will be built in April and May, respectively. Alpha keeps lumber on hand at 40% of the next month's production needs. Use this information to determine number board feet of lumber that Alpha Company: (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units.)

should buy in April
have for desired March ending raw material inventory

2. Alpha company makes units that each requires 2 pounds of material at $3 per pound. Alpha is planning that 500 and 700 units will be built in May and June, respectively. Alpha keeps material on hand at 20% of the next month's production needs. Use this information to determine: (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)

Raw Material Costs for May's Production
Total Cost of May's Raw Materials Purchases

3. Alpha company anticipated unit sales of widgets are January, 5,000; February, 4,000; and March 8,000. Alpha consistently maintained finished goods inventory at 80% of the following month's sales. The historic total unit cost has been $10 for each unit produced. Use this information to determine the total cost of completed production for: (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)

January
February

4. Alpha company anticipated unit sales of widgets are January, 5,000; February, 4,000; and March 8,000. Alpha consistently maintained finished goods inventory at 80% of the following month's sales. Use this information to determine: (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)

the total number of units that Alpha Company must produce in January.
the total number of units that Alpha Company must produce in February.

5. Alpha Company began operations on January 1 with cash of $75,000. All of January's $150,000 sales were on account. During January no customer collections occurred. Cost of goods sold was $40,000, and there was no ending inventories or any accounts payables. Use this information to determine the ending balance of cash on hand for January. (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)

6. Alpha Company has budgeted activity for October to reflect net income $120,000. All sales are credit sales. Receivables are planned to increase by $35,000, payables to decrease by $25,000 and Depreciation Expense is $55,000. Use this information to determine how much cash will increase (decrease) during the month of October. (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)

7. Alpha Company began operations on January 1. All sales are on credit. Alpha has sales budgeted as $170,000 for February. Receivables at January 31 were $25,000. Accounts Receivable collections are expected to be 60% in the month of sale, 30% the next month, and 10% in the next. Use this information to determine the dollar value of: (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)

January Sales
January Cash Collections from Customers
February Expected Cash Collections from Customers

8. Alpha Company is preparing its cash budget for the month of May. The company estimated credit sales for May at $200,000. Actual credit sales for April were $150,000. Estimated collections in May for credit sales in May are 20%. Estimated collections in May for credit sales in April are 70%. Estimated Collections in May for credit sales prior to April are $12,000. Estimated write-offs in May for uncollectible credit sales are $8,000. Estimated provision for bad debts in May for credit sales in May are $7,000. What are the estimated cash receipts from accounts receivable collections in May?

9. Alpha Company has provided projected information as follows:

Net sales $10,000

Fixed manufacturing costs $1,000

Additionally, Alpha has experienced a variable manufacturing costs of 45% of net sales and sees not changes during the budget period. Alpha expects that there will be no changes to any inventory values. Use this information to determine Alpha's: . (Round & enter final answers to: the nearest whole dollar for total dollar answers, nearest penny for unit costs or nearest whole number for units)