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.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 50E: Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces...
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
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
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
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT