Explore BrainMass

Production Budget for Borders Manufacturing

Not what you're looking for? Search our solutions OR ask your own Custom question.

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

I desperately need help with this problem. Can someone help me please?

Borders Manufacturing is developing a sales and production plan as part of its master budgeting process. Following are the projected monthly sales, which occur uniformly during each month for the upcoming year (see attached)

Production for each month equals one-half of the current month's sales plus one-half of the next month's projected sales. Develop the production plan for Borders Manufacturing for the up coming year.

Solution Preview

Problem: Production for each month equals one-half of the current month's sales plus one-half of the next month's projected sales. Develop the production plan for Borders Manufacturing for the up coming year.

Solution:
Please see the attached Excel spreadsheet for the full solution with workings. ...

Solution Summary

This posting helps with a problem about operating budgets. The solution explains how to make a production plan given the sales budget and the inventory requirements. The answers are given in an Excel spreadsheet.

\$2.49