Budget project mba accounting completed project should be submitted

Budget Project MBA Accounting                                                                                                                       Completed project should be submitted in an EXCEL workbook format with a separate page for each schedule.                                                                                                                       Using the following information you are to prepare a comprehensive budget for River City Micro Systems, Inc. The Company assembles a specialized device used in airports to detect certain types of explosives to prevent terrorist attacks.                                                                                                                 Arrangements have been made for the component parts (bundled in packets, one per unit) to be produced in Indonesia, shipped to Boise, then assembled and sold by River City Micro to the end users.                                                                                                                       You have developed the prototypes, established a market, and now you are putting together a budget for the first three months of 2015.  The Company will actually start manufacturing and distribution on January 2, 2015.  The purpose of this comprehensive budget is to formalize your expected income, cash flow and balance sheets.                                                                                               From the following information you are to prepare the following schedules/statements for the months ending January 31, 2015, February 28, 2015 and March 31, 2015:                                                                                                                         1)  Projected units of production                                                                                                                         2)  Projected raw material requirements                                                                                                                         3)  Projected raw material purchases in dollars                                                                                                                         4)  Projected cost of goods manufactured statement                                                                                                                         5) Pro-forma income statement                                                                                                                         6) Pro-forma cash flow statement                                                                                                                         7) Pro-forma balance sheet                                                                                                                         8) Capital lease amortization schedule                                                                                                                         9) Depreciation schedule                                                                                                                         You should utilize the following assumptions in making your calculations:                                                                                                                       a.  Projected sales in units are as follows: January = 500, February = 600, March = 600, April and following months = 800.  At the start of each month the management plans to have 30 days, (1 month) of direct materials on hand.  Each packet of direct material costs $80.00. The company will have 800 units on hand on January 1, 2015 (all purchased during December 2014).                                                                                         b.  Ten hours of direct labor are required to assemble each device. The direct labor cost (including fringe benefits) is $35.00 per hour.                                                                                                                       c.  Manufacturing overhead is 50% of direct labor cost.                                                                                                                       d.  Devices are sold at 100% markup on cost.                                                                                                                       e.  The company wants to have at least 50% of next months projected sales in ending finished goods inventory each month.                                                                                                                       f.  Direct materials purchases are paid for on the 10th day of the month following month of purchases.                                                                                                                       g.  Manufacturing overhead is paid 25% in cash and with the balance paid in 30 days.                                                                                                                       h.  Wages earned by employees during the first half of each month are paid on the 22nd with the remainder paid on the 7th of the following month. Assume that workforce is stable each month (hence, wages and salaries are the same every day of the month).                                                                                                             i.  On January 1, 2015 you acquire equipment and finance it 100% through a capital lease. Life of equipment is 60 months with no salvage value.  Capital lease payments are $12,000 per month including an imputed interest component. Your cost of capital is 10%. Use this rate to calculate the present value of the cash payments and the present value of the lease principal as of January 1, 2014. The first payment is due on February 1, 2015.                                                                           j.  Selling commissions are 10% of sales price.  These are paid on the 15th day of the month following month of sale.                                                                                                                       k.  Administrative salaries and fringe benefits are $60,000 per month payable on schedule outlined in h.                                                                                                                         l.  Rent is $8,000 per month payable on the first day of each month.                                                                                                                       m. On January 1, 2015 the Company will pay 6 months insurance premiums in advance for a total of $24,000.                                                                                                                       n.  Other general and administrative expenses are estimated to be 15% of sales.  They are paid in the month after they are incurred.                                                                                                                       o.  The company has a $500,000 line of credit secured by inventory and accounts receivable.  Borrowing against this line must be in increments of $50,000.  Interest is 12% per annum and is payable on the 1st day of the month following the borrowing.  Assume all borrowing occur on the 15th day of the month.  Repayments must also occur in $50,000 increments on the 15th day of the month.                                                                                     p.  All sales are on account and are collected 15% in month of sale, 75% in next month and the balance in the following month.                                                                                                                       q.  Income tax rate is 35%. Taxes accrue on each month’s income and are paid in arrears on January 15, Apr 15, Jul 15 and Oct 15 for the preceding quarter. Note: any expected losses create tax benefits that can be used in reduce taxes paid in future quarters.                                                                                                               r.  Beginning cash balance on January 1, 2015 is projected to be $100,000 that was raised through the sale of capital stock in December 2014.                                                                                                                       2. Complete the project as a group assignment. Different tasks can be assigned to various group members but everyone needs to actively participate.                                                                                                                       3. Check figures will be supplied at various times over the next ten days.                                                                                                                       4.Submit one final copy for a group. All group member names must appear on each schedule.                                                                                                                       5. Submit all of your answers as a single multi-tabbed Excel workbook from the assignment module. If you have difficulty submitting the Excel file from the assignment module you can attach the workbook to an email.                                                                                                                      6. Please be patient as I take time to grade this written assignment. You may want to check your gradebook from time to time over the next week to read any feedback I provide and see your grade.                                                                                                                                                                                  
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Leadership Studies
excellent job
Customer 456821, July 30th, 2022
good job
Customer 456821, October 24th, 2022
Customer 453413, April 29th, 2020
Business and administrative studies
Thank you!
Customer 453187, February 21st, 2022
English 101
Thank you!
Customer 454351, May 9th, 2020
Customer 452441, April 7th, 2022
Excellent work
Customer 456821, March 22nd, 2022
Good work.
Customer 462931, May 4th, 2022
The assignment was good, but needed to be revised due to misunderstanding with the original instructions.
Customer 452455, May 8th, 2023
As I expected.
Customer 460551, November 23rd, 2021
Business and administrative studies
Always use Grammarly Premium.
Customer 462795, April 3rd, 2022
Quality work. Looking forward to your future contributions.
Customer 463467, December 2nd, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat