Explore BrainMass
Share

Budgets : key information

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

*Please describe how to calculate.

ABC company started business on January 1, 2010. The company estimated that sales for the first six months would be as attaches:

*Please look at the attachment

The Company sells all items on account and expects collections of accounts receivable to be as follows: 60% in the month of the sale, and the remaining 40% in the month after the sale.

A) Compute the expected cash collections during the months of January, February, March, April, May, and June.

B) The company has decided that finished goods inventory at the end of each month should ideally be equal to 40% of next month's sales. What should budgeted production be for each of the first four months?

C) It takes two pounds of raw material to make one unit of finished product. The company wants to keep an ending inventory of raw material equal to 30% of next month's production needs. How many pounds of raw material should be purchased in each of the first three months?

D) The raw material costs $2 per pound. The company pays for 70% of its purchases during the month of purchase and the remainder in the following month. How much cash will be disbursed during the month of March for the purchase of of raw material?

E) The projected cash balance on March 1 is $13,500. What is the estimated cash balance at the end of the month? (Prepare a formal cash budget for the month of March.)

© BrainMass Inc. brainmass.com October 25, 2018, 2:47 am ad1c9bdddf
https://brainmass.com/business/cash-budgeting/budgets-key-information-315282

Attachments

Solution Summary

The solution explains how to calculate the expected cash collection, budgeted production, purchases and the ending cash balance

$2.19
See Also This Related BrainMass Solution

OCA Cash Balance Tool

Project Selection: OCA Cash Balance Table

The project we have been working on is the enhancement of budget process by using a new tool, an excel table named "OCA Cash Balance", to monitor that FLAIR trust fund cash balances on grant OCAs during and after a grant cycle and avoiding the over or under spend of federal, state and local funds; this in turn helps to reduce the overload on the staff. The new tool has been already used for some of the programs with excellent results.

The strategic planning is based on the improvement of the Budget process in the Florida Department of Health in Miami-Dade County to be in compliance with the state rules and regulations and the maximization of revenues by avoiding over or under spending.

To achieve this plan we focus on:
• Avoiding over or underspending of the federal, state, and local fund allocations.
• The utilization of an excel table that if used with the correct information gives a good estimated of the cash balance per OCA.
• The information used in the table is retrieved from reliable sources such as the Schedule C, FIS , the On-demand Reports, and the Encumbrance Report.
• Provide budget analyst with the ability to advise program managers of any needed action and to project revenues and expenditures with accuracy.
• To improve customer service and/or communication with the program managers and to rectify, in a short period of time, any inconsistency.
• The control and timeliness compliance with Budget Program guidelines and regulations.
• Quality Improvement by providing budget analyst with training and updates.
• Implement the enhancement process with the participation and involvement of the Budget Office Team.

Prior to the Implementation of the Table of Cash Balance:

Key problems and issues

• By the end of the grant period, many of the grants have ended with deficit or surplus. For some local and state grants, a carry-over was a normal trend; on the other hand, the unspent federal funds needed to be returned to the Central Office in Tallahassee.
• Stressful environment with high workload and discouragement on the staff since it was not easy to balance the OCAs at the end of the grant period.
• The analyst used several sources to monitor the grants but failed to put all information together to have a better picture of the OCA balances.
• It took several months to the budget analysts to have a good estimated of the balance of the funds.

Current Cash Balance Process:

The OCA Cash Balance Table has been implemented for some of the grants with extraordinary results and the process of balancing OCAs has tremendously improved the monitoring of FLAIR trust fund cash balances during and after a grant cycle. By the end of the grant period, the OCAs end in "zero" balance. The budget analysts include the prior and current allocation, prior or current expenses, up-to day encumbrances, estimated pending salaries, and any recurring expenses. This tool is easy to understand not only by the analyst but also by the program managers who can project revenues and expenditures using the information from this table.

Implementation and Impact

• Budget analysts provide, in a monthly basis, the cash balance of the grants to the program managers.
• The analyst have more time to complete other tasks because, when it is needed, they only have to update the table with the most recent information as all the data is included since the beginning of the grant period.
• The staff has been trained in the new process so the process is completed in less time with less number of errors.
• After the implementation of the new Cash Balance Table, there is less stress on the staff since the workload has been reduced and the confidence has increased.
• Customer satisfaction has improved due to the strictness of the budget analysts to provide programs managers with accurate information.
• This provides Miami-Dade the ability to reach, as a metro county, an overall cash balance of 7% - 9% to ensure compliance with cash balance requirements.
• This new OCA cash balance process aims Miami-Dade Budget Office to align the estimated revenues balances with the FIRS Spending Plan projected revenue balance.

Strategic Planning:

The strategic planning for this project started with an extensive analysis of the root-causes and issues of the problems, and challenges faced by the Budget Office. An extensive analysis of the budget office's key strengths and weaknesses was also conducted in order to ascertain the readiness of the organization to implement the new OCA balances process.

Based on the above mentioned analysis, goals and objectives along with the action plan for implementing the new process was finalized. The inputs from the budget's staff were also integrated in the formulation of the strategic implementation plan. Control checks and monitoring mechanisms along with a risk management plan was also formulated to address challenges associated with the implementation process.

After the plan was finalized, the actual implementation was started and completed as per the original scope, schedule and budget finalized by the project team.

The project was closed with a proper closure process which involved documenting the key lessons learned during the project along with all the information pertaining to the project, so that the organization can refer to the project document to improve other processes in the future.

The post implementation phase consists of routine monitoring and control checks to ascertain the impact of the new process on the overall productivity and efficiency of the new OCA cash balance process.

View Full Posting Details