Question

In: Accounting

Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their...

Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley’s financial performance:

Beginning-of-period balances:

Accounts Receivable: $54,000

Accounts Payable: $27,000

Accumulated Factory Depreciation: $288,000

Cash: $13,500

Estimates for end-of-period balances:

Accounts Receivable: $67,500

Accounts Payable: $18,000

Accumulated Factory Depreciation: $296,000

Budgeted activity levels for the period:

Sales: $250,000

Purchases of Direct Materials: $44,800

Direct Labor Wages: $75,000

Manufacturing Overhead: $25,000

Selling and Administrative Expenses: $42,000

Except for purchases of direct materials, all expenses are paid as incurred.

What is the budgeted ending cash balance for the period?

A. $76,700

B. $62,200

C. $89,200

D. $70,200

Solutions

Expert Solution

In case you have any query, kindly ask in comments.

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their...
Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley’s financial performance: Beginning-of-period balances: Accounts Receivable: $54,000 Accounts Payable: $27,000 Accumulated Factory Depreciation: $288,000 Cash: $13,500 Estimates for end-of-period balances: Accounts Receivable: $67,500 Accounts Payable: $18,000 Accumulated Factory Depreciation: $296,000 Budgeted activity levels for the period: Sales: $250,000 Purchases of Direct Materials: $44,800 Direct Labor Wages: $75,000 Manufacturing...
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year....
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year. The following information concerns the company’s upcoming cash receipts and disbursements. Sales are 65% cash and 35% credit. Credit sales are collected 30% in the month of sale and the remainder in the month after the sale. Actual sales in December were $51,000. January sales are budgeted to be $60,000; February sales are budgeted to be $69,000 Actual purchases of direct materials in December...
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year....
Roan’s manufacturing is preparing its cash budget for the first two months of the upcoming year. The following information concerns the company’s upcoming cash receipts and disbursements. Sales are 65% cash and 35% credit. Credit sales are collected 30% in the month of sale and the remainder in the month after the sale. Actual sales in December were $51,000. January sales are budgeted to be $60,000; February sales are budgeted to be $69,000 Actual purchases of direct materials in December...
Forest Trails is preparing their budgeted financial statements for the coming period, and has accumulated the...
Forest Trails is preparing their budgeted financial statements for the coming period, and has accumulated the following data: Beginning-of-period balances: Cash: $13,500 Accounts Receivable: $54,000 Raw Materials Inventory: $16,000 Work in Process Inventory: $60,000 Finished Goods Inventory: $24,000 Equipment (historical value): $480,000 Accumulated Depreciation: $288,000 Accounts Payable: $27,000 Estimates for end-of-period balances: Accounts Receivable: $67,500 Raw Materials Inventory: $10,000 Work in Process Inventory: $50,000 Finished Goods Inventory: $29,000 Accumulated Depreciation: $296,000 Accounts Payable: $18,000 Budgeted activity levels for the period:...
The City of Pleasant Valley adopted the following budget for its general fund for the upcoming...
The City of Pleasant Valley adopted the following budget for its general fund for the upcoming fiscal year. Estimated revenues: Taxes                                     $5,000,000 Intergovernmental revenues 1,000,000 Licenses and permits 400,000 Fines and forfeits 150,000 Miscellaneous revenues       100,000 Total estimated revenues $6,650,000 Appropriations: General government           $2,000,000 Public safety                          2,200,000 Public works 950,000 Health and welfare                   850,000 Miscellaneous                              50,000 Total appropriations            $5,950,000 Prepare a summary general journal entry to record the adopted budget at the beginning of...
ABC Company is in the process of preparing a budget for the upcoming year. The marketing...
ABC Company is in the process of preparing a budget for the upcoming year. The marketing department has just increased the number of units in the sales budget by a significant 50% as compared to the last sales budget that was prepared for the year. Explain the impact this change will have on the Contribution Margin Income Statement. Be specific about… how the components of the Income Statement will be affected. what company managers must do differently to implement the...
explain meaning of the budget, the reason for preparing the budget, the period for which the...
explain meaning of the budget, the reason for preparing the budget, the period for which the budgets are prepared, along with the justification of why the budget is important for these budget sales budget, cost of production budget, cash budget, purchade budget
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised...
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30,000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the coming year, despite an increase in fees to $3,000 per subject. The following additional information has been gathered from an examination of university records and conversations with university managers:  South Hampton is...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT