2023 This is a comprehensive problem all contained on this spreadsheet tab Cash Budget Below is summary | Assignments Online
2023 This is a comprehensive problem all contained on this spreadsheet tab Cash Budget Below is summary | Assignments Online
Assignments Online 2023 Business Finance
| This is a comprehensive problem all contained on this spreadsheet tab. | ||||||
| Cash Budget | ||||||
| Below is summary monthly income statement data for Ace Manufacturing Company. | ||||||
| January | February | |||||
| Sales revenue | 275,000 | 250,000 | ||||
| Direct materials purchases | 60,000 | 70,000 | ||||
| Direct labor | 88,000 | 95,000 | ||||
| Manufacturing overhead | 60,000 | 62,000 | ||||
| Selling and administrative expenses | 45,000 | 46,000 | ||||
| All sales are on account, and history has shown that 40% of sales is expected to be collected in the month of the sale, with 60% collected the following month. | ||||||
| Direct materials are paid 50% in the month of purchase and 50% the following month. All other expenses are paid as incurred. All costs shown are cash-based costs (depreciation has already been eliminated). | ||||||
| Other data: | ||||||
| 1. December sales were $240,000. | ||||||
| 2. Purchases of direct materials purchased in December were $50,000. | ||||||
| 3. The company has interest payments due of $5,000 per month. | ||||||
| 4. The cash balance on January 1 was $15,000. | ||||||
| Instructions | ||||||
| A. Prepare schedules for expected collections from customers and expected payments for direct materials purchases. | ||||||
| B. Prepare a cash budget for January and February. | ||||||
Assignmentsonline.org help students to solve their assignment in the best possible manner. In the assignment help industry, we are regarded as one of the best helpers for students’ tasks in all subjects. We provide solutions to students from all corners of the world, but the main focus is from students residing in the US, UK, and Australia. Our primary focus is solving student assignments for all subjects and streams.
Place Order NOw
Assignment online is a team of top-class experts whose only goal is to give you the best assignment help service. Follow the link below to order now...
#write essay #research paper
