How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month following the sale. Operating supplies are paid for in the month of purchase. Selling and administrative expenses and processing overhead are paid in the month following the cost’s incurrence. The division has a bank loan of $12,000 with a 12 percent annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on February 28 of next year. Income taxes of $4,550 for this calendar year are due and payable on March 15 of next year. The information specialists earn $8.50 an hour, and all payroll-related employee benefit costs are included in processing overhead. The division anticipates no capital expenditures for the first quarter of the coming year. It expects its cash balance on December 31 of this year to be $13,840. Prepare a monthly cash budget for the Information Processing Division for the three month period ending March 31 of the current year. Comment on whether the ending cash balances are adequate for the division’s cash needs.

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 38P: Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven,...
icon
Related questions
icon
Concept explainers
Question
100%

How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month following the sale. Operating supplies are paid for in the month of purchase. Selling and administrative expenses and processing overhead are paid in the month following the cost’s incurrence. The division has a bank loan of $12,000 with a 12 percent annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on February 28 of next year. Income taxes of $4,550 for this calendar year are due and payable on March 15 of next year. The information specialists earn $8.50 an hour, and all payroll-related employee benefit costs are included in processing overhead. The division anticipates no capital expenditures for the first quarter of the coming year. It expects its cash balance on December 31 of this year to be $13,840. Prepare a monthly cash budget for the Information Processing Division for the three month period ending March 31 of the current year. Comment on whether the ending cash balances are adequate for the division’s cash needs.

Expert Solution
steps

Step by step

Solved in 2 steps

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