Question
Elwood Company has the following projected costs for manufacturing and selling and administrative expenses: (Click the icon to view the projected costs.) Prepare a schedule
Elwood Company has the following projected costs for manufacturing and selling and administrative expenses: (Click the icon to view the projected costs.)
Prepare a schedule of cash payments for Elwood for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (If an input field is not used in the table leave the input field empty; do not enter a zero.)
January | February | March | |
---|---|---|---|
Direct materials purchases | $3,000 | $4,500 | $4,900 |
Direct labor costs | 3,400 | 3,900 | 3,800 |
Depreciation on plant | 450 | 450 | 450 |
Utilities for plant | 950 | 950 | 950 |
Property taxes on plant | 300 | 300 | 300 |
Depreciation on office | 100 | 100 | 100 |
Utilities for office | 350 | 350 | 350 |
Property taxes on office | 120 | 120 | 120 |
Office salaries | 6,000 | 6,000 | 6,000 |
All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2nd. the accounts payable and utilities payable accounts have a zero balance on January 1st |
|
| January | February | March | Total |
Cash Payments |
|
|
|
| |
Direct Materials: |
|
|
|
| |
Accounts Payable balance, January 1 |
|
|
|
| |
JanuaryDirect material purchases paid in February |
|
|
|
| |
FebruaryDirect material purchases paid in March |
|
|
|
| |
Total payments for direct materials |
|
|
|
| |
|
|
|
|
|
|
Direct Labor: |
|
|
|
| |
Total payments for direct labor |
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started