Accounting Artifacts is a business created to sell lifesize abaci. Below are details regarding the budgetary assumpts for quarter three. Month July August September October ABCDwu Complete the following instructions: A. B. C. D. E. F. Office Salaries $35,000/month Sales price per unit is $180 Plans are to have an inventory of finished product equal to 20% of the unit sales for the next month. There was 4,000 units in beginning inventory on July 1st. Three pounds of materials are required for each unit produced. Each pound of material costs $20. Inventory levels for materials equal 30% of the needs for the next month. Desired ending inventory for September is 25,200 pounds of material. Beginning inventory for July was 20,700 pounds of material. Each unit requires 0.6 hours of direct labor and the average wage rate is $16 per hour. Variable overhead rate is $3.50 per direct labor hour. There is also fixed overhead of $22,000 per month. Cost of goods sold is $72.50 per unit The balance in common stock was $3 million at the beginning of the quarter. The balance in retained earnings was $1,634,442 at the beginning of the quarter. Accounts receivable had a beginning balance of $1,200,000. Seventy percent of sales are collected in the month of sale and 30 percent are collected in the following month. Accounts payable had a beginning balance of $900,000. Forty percent of purchases are paid for in the month of purchase and 60 percent are paid for the following month. Cash had a beginning balance of $2,000,000 on July 1. The company pays a 3% commission on sales. The company issued an additional $57,600 in common stock during the period. Company has fixed selling and administrative expenses as follows: Rent $6,000/month Utilities $1,200/month Advertising $400/month Prepare a sales budget and schedule of expected cash follections for the quarter. Prepare a production budget for the quarter. Unit Sales 20,000 35,000 25,000 30,000 Prepare a direct labor budget in hours and total cost for the quarter. Prepare a manufacturing overhead budget for the quarter. Prepare a selling and administrative expense budget for the quarter. Prepare a direct materials budget in pounds and dollars for the quarter and schedule of expected cash disbursements.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 15E: Palmgren Company produces consumer products. The sales budget for four months of the year is...
icon
Related questions
icon
Concept explainers
Question

Please answer parts D, E, and F from the attached instructions

Accounting Artifacts is a business created to sell lifesize abaci. Below are details regarding the budgetary assumpts
for quarter three.
Month
July
August
September
October
A.
ABC
B.
Complete the following instructions:
D.
DEFG
E.
F.
G.
H.
I.
Sales price per unit is $180
Plans are to have an inventory of finished product equal to 20% of the unit sales for the next month.
There was 4,000 units in beginning inventory on July 1st.
Three pounds of materials are required for each unit produced. Each pound of material costs $20.
Inventory levels for materials equal 30% of the needs for the next month.
Desired ending inventory for September is 25,200 pounds of material. Beginning inventory for July
was 20,700 pounds of material.
Each unit requires 0.6 hours of direct labor and the average wage rate is $16 per hour.
Variable overhead rate is $3.50 per direct labor hour. There is also fixed overhead of $22,000 per
month.
Cost of goods sold is $72.50 per unit
The balance in common stock was $3 million at the beginning of the quarter. The balance in retained
earnings was $1,634,442 at the beginning of the quarter.
Accounts receivable had a beginning balance of $1,200,000. Seventy percent of sales are collected
in the month of sale and 30 percent are collected in the following month.
Accounts payable had a beginning balance of $900,000. Forty percent of purchases are paid for in
the month of purchase and 60 percent are paid for the following month.
Cash had a beginning balance of $2,000,000 on July 1.
The company pays a 3% commission on sales.
The company issued an additional $57,600 in common stock during the period.
Company has fixed selling and administrative expenses as follows:
Rent $6,000/month
Utilities $1,200/month
Advertising $400/month
Unit Sales
20,000
35,000
25,000
30,000
Office Salaries $35,000/month
Prepare a sales budget and schedule of expected cash follections for the quarter.
Prepare a production budget for the quarter.
Prepare a direct materials budget in pounds and dollars for the quarter and schedule of expected
cash disbursements.
Prepare a direct labor budget in hours and total cost for the quarter.
Prepare a manufacturing overhead budget for the quarter.
Prepare a selling and administrative expense budget for the quarter.
Prepare a cash budget for the quarter.
Prepare a budged income statement for the quarter-the corporation pays 21% of net operating
income in federal income taxes (the state is incorporated in South Dakota where there is no state
income tax).
Prepare a budgeted balance sheet at the end of the quarter.
Transcribed Image Text:Accounting Artifacts is a business created to sell lifesize abaci. Below are details regarding the budgetary assumpts for quarter three. Month July August September October A. ABC B. Complete the following instructions: D. DEFG E. F. G. H. I. Sales price per unit is $180 Plans are to have an inventory of finished product equal to 20% of the unit sales for the next month. There was 4,000 units in beginning inventory on July 1st. Three pounds of materials are required for each unit produced. Each pound of material costs $20. Inventory levels for materials equal 30% of the needs for the next month. Desired ending inventory for September is 25,200 pounds of material. Beginning inventory for July was 20,700 pounds of material. Each unit requires 0.6 hours of direct labor and the average wage rate is $16 per hour. Variable overhead rate is $3.50 per direct labor hour. There is also fixed overhead of $22,000 per month. Cost of goods sold is $72.50 per unit The balance in common stock was $3 million at the beginning of the quarter. The balance in retained earnings was $1,634,442 at the beginning of the quarter. Accounts receivable had a beginning balance of $1,200,000. Seventy percent of sales are collected in the month of sale and 30 percent are collected in the following month. Accounts payable had a beginning balance of $900,000. Forty percent of purchases are paid for in the month of purchase and 60 percent are paid for the following month. Cash had a beginning balance of $2,000,000 on July 1. The company pays a 3% commission on sales. The company issued an additional $57,600 in common stock during the period. Company has fixed selling and administrative expenses as follows: Rent $6,000/month Utilities $1,200/month Advertising $400/month Unit Sales 20,000 35,000 25,000 30,000 Office Salaries $35,000/month Prepare a sales budget and schedule of expected cash follections for the quarter. Prepare a production budget for the quarter. Prepare a direct materials budget in pounds and dollars for the quarter and schedule of expected cash disbursements. Prepare a direct labor budget in hours and total cost for the quarter. Prepare a manufacturing overhead budget for the quarter. Prepare a selling and administrative expense budget for the quarter. Prepare a cash budget for the quarter. Prepare a budged income statement for the quarter-the corporation pays 21% of net operating income in federal income taxes (the state is incorporated in South Dakota where there is no state income tax). Prepare a budgeted balance sheet at the end of the quarter.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning