Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below is summary monthly income statement data for Ace Manufacturing Company. January Feburary Sales Revenue 250,000 275,000 Direct Materials Purchases 60,000 70,000 Direct Labor 88,000

Below is summary monthly income statement data for Ace Manufacturing Company.

January Feburary
Sales Revenue 250,000 275,000
Direct Materials Purchases 60,000 70,000
Direct Labor 88,000 95,000
Manufacturing Overhead 50,000 52,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 $230,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.

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

The Budget Bible Budgeting Made Simple

Authors: Jessica Charise Brant, Adrienne Homet Hand

979-8218059880

More Books

Students also viewed these Accounting questions

Question

What is shift scheduling and how is it done?

Answered: 1 week ago