Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wildhorse Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. January February Sales $439,200 $488,000 Direct materials purchases 146,400

Wildhorse Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows.

January

February

Sales $439,200 $488,000
Direct materials purchases 146,400 152,500
Direct labor 109,800 122,000
Manufacturing overhead 85,400 91,500
Selling and administrative expenses 96,380 103,700

All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,220 of depreciation per month. Other data:

1. Credit sales: November 2021, $305,000; December 2021, $390,400.
2. Purchases of direct materials: December 2021, $122,000.
3. Other receipts: JanuaryCollection of December 31, 2021, notes receivable $18,300; FebruaryProceeds from sale of securities $7,320.
4. Other disbursements: FebruaryPayment of $7,320 cash dividend.

Is this the correct answer I only have 1 more try for this question? The companys cash balance on January 1, 2022, is expected to be $73,200. The company wants to maintain a minimum cash balance of $61,000.

Cash Budget choose the accounting period For the Two Months Ending February 28, 2022 January February select an opening cash budget item Beginning Cash Balance $enter a dollar amount 73200 $enter a dollar amount 62,220 select between addition and deduction Add : select an opening name for section one Receipts select a cash budget item Collections from Customers enter a dollar amount 397,720 enter a dollar amount 453,840 select a cash budget item Notes Receivable enter a dollar amount 18,300 enter a dollar amount 0 select a cash budget item Sale of Securities enter a dollar amount 0 enter a dollar amount 7,320 select a closing name for section one Total Receipts enter a total amount for section one 416,020. enter a total amount for section one 453,840 select a summarizing line for the first part Total Available Cash enter a total amount for the first part 489,220. enter a total amount for the first part 523,380. select between addition and deduction Less : select an opening name for section two Disbursements select a cash budget item Direct Materials enter a dollar amount 136,640. enter a dollar amount 150,060 select a cash budget item Direct Labor enter a dollar amount 109,800 enter a dollar amount 122,000 select a cash budget item Manufacturing Overhead enter a dollar amount 85,400 enter a dollar amount 91,500 select a cash budget item Selling and Administrative Expenses enter a dollar amount 95,160 enter a dollar amount 102,480 select a cash budget item Cash Dividend enter a dollar amount 0 enter a dollar amount 7,320 select a closing name for section two Total Disbursements enter a total amount for section two 427,000 enter a total amount for section two 473,360 select a summarizing line for the second part Excess (Deficiency) of Available Cash Over Cash Disbursements enter a total amount for the second part 62,220. enter a total amount for the second part 50,020.00 select an opening name for section three Financing select between addition and deduction Add : select a cash budget item Borrowings enter a dollar amount enter a dollar amount 10980. select between addition and deduction Less : select a cash budget item Repayments enter a dollar amount 0 enter a dollar amount 57340. select a closing cash budget item Ending Cash Balance $enter a total amount for the cash budget 62,220 $enter a total amount for the cash budget 61,000.

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

Students also viewed these Accounting questions