Revenues and production budget, Financial Accounting

Assignment Help:

The assignment requires a significant part of the work to be done in a spreadsheet. I have not nominated any particular vendoar or any particular version. The choice is up to you, but you must ensure that you do the work where required in a spreadsheet.

Any student who does not do the work required in a spreadsheet will be deemed to have attempted to have circumvented the assignment and therefore will receive no marks for this part of the assignment.

I reserve the right to require you to supply the spreadsheet in soft form and then explain to your lecturer how the assignment was prepared using that spreadsheet.

As a suggestion you could do some of the review exercises nominated in the Study Guide as Excel during the term. Some of these have pro forma spreadsheets available from the textbook publisher's web site. You can also consider doing the assignment by hand so you get to know what you are doing from an accounting perspective. Then you can go ahead and incorporate that into the spreadsheet abiding by the requirements of the assignment.

If you are unsure of the spreadsheet functions then there are help facilities within most spreadsheet software, there are texts in most libraries, and also material is available from the web. In addition to these sources, any student who is experiencing difficulty with spreadsheets should contact the Learning Centre at the campus and the local lecturer.

All calculation work for this assignment is to be done using a spreadsheet. In the spreadsheet, you are to use three sheets:

Input Processing, and Output.

All data that is to be used in the calculations is to be entered into the Input sheet. All calculations are to be performed in the Processing sheet. Note that all calculated values required in the Processing sheet must come from the Input sheet. The Output sheet is to allow you to choose the appropriate format in which to present your answers to the assignment. All values in the Output sheet must come from the Processing sheet.

At the top of each page of the Input, Processing or Output sheet you are to show your student number, the name of the sheet and the name of the firm.

You are to design the spreadsheet so that the only numeric values that can be altered by staff are located in the Input sheet. All textual values must not be able to be altered.

Part B of the assignment must start on a new page.

For each sheet, you are to print a report from the spreadsheet that shows the rows and columns together with any formula that has been used in each cell of the sheet.

You are to print a standard report of each sheet showing the value of all cells. Thus this part requires you to print the results direct from the spreadsheet and not to type or cut and paste into a word document.

In a word document, you are to explain the layout of the spreadsheet so that staff will be able to read the details and then be able to use the spreadsheet.

In a separate part of the word document, explain how you have secured the spreadsheet so that it can not easily be altered by staff.

Required

1. Prepare the following budgets for March 2009:

(a) Revenues budget

(b) Production budget in units

(c) Direct material usage budget and direct material purchases budget

(d) Direct manufacturing labour budget

(e) Manufacturing overhead budget

(f) Ending inventories budget (direct materials and finished goods)

(g) Cost of goods sold budget

2. Suppose Top Dog Quality Furniture decides to incorporate continuous improvement into its budgeting process. Describe two areas where Top Dog Quality could incorporate continuous improvement into the budget schedules in requirement 1.


Related Discussions:- Revenues and production budget

Calculation of internal rate of return, Q. Calculation of internal rate of ...

Q. Calculation of internal rate of return? The company is accurate in its belief that NPV measures the potential increase in company value of an investment project since theore

SOURCES OF FUNDS, In spite of the ordinary shares ranking last in terms of ...

In spite of the ordinary shares ranking last in terms of assets sharing in the event of liquidation, they attract more investors than any other type of shares. Why do you think thi

Prepare journal entries to record liquidation transaction, Terry Marks is a...

Terry Marks is a well-known architect. He wants to start his own business and convinces Rob Norris, his cousin and a civil engineer, to contribute capital. Together, they form a pa

Determine the net present value for the project, An investment project requ...

An investment project requires a net investment of $100,000. The project is expected to generate annual net cash inflows of $28,000 for the next 5 years. The firm's cost of capital

Explain the auditing standards, Q. Explain the Auditing Standards? Audi...

Q. Explain the Auditing Standards? Auditing Standards - Guidelines to which an AUDITOR adheres. Auditing standards encompassauditor's professional qualities, as well as her or

Me, what is the different between prorfit and margin prorfi

what is the different between prorfit and margin prorfi

Quarterly cash dividends are planned, Given the information that follows, d...

Given the information that follows, draw a cash budget for the XYZ Store for the first six months of 2012. Every prices and costs remain constant. Sales are 80% for credit

OPERATING CYCLE, #question.DISCUSS THE APPLICABILITY OF AN OPERATING CYCLE ...

#question.DISCUSS THE APPLICABILITY OF AN OPERATING CYCLE IN POULTRY BUSINESS.

Estimate cost of equity using dividend valuation model, Q. Estimate cost of...

Q. Estimate cost of equity using dividend valuation model? The cost of equity may be approximate using either the dividend valuation model or the capital asset pricing model. I

Percent Gain, Assume you invest $150 per month in a stock. Stock prices are...

Assume you invest $150 per month in a stock. Stock prices are as follows: January $10.50, February $9.75, March $9.50, April $11.00, May $10.75, June $9.75, July $9.00, August $8.5

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd