Log in
Accounting
2
answers
0
watching
8
views
26 Nov 2019

Use the following data to calculate UCL and LCL (at the 99.7%confidence level) for an X-bar Chart that had 20 subgroups of size6. The sum of X-bar is 60.54 and the sum of R is 38.92

Watch
2
answers
0
watching
8
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Unlock all answers

Get 1 free homework help answer.
Get unlimited access
Already have an account? Log in
Share
Trinidad Tremblay
Trinidad TremblayLv2
22 May 2019
Get unlimited access
Already have an account? Log in
Share

Related questions

Using the information in Table MA.4, advise the marketing director on whether it

would be more beneficial to make fruit and nut bars rather than buy them in from

another company for £1.70 per bar. What other considerations need to be taken into

account?

Table MA.1 Volume chocolate bars

Selling price per bar £

Cocoa

grams per

bar

Sugar

grams per

bar

Milk

millilitres

per bar

Dark

80,000

2.00

170

30

0

Milk

140,000

1.80

130

40

30

White

60,000

2.00

0

70

130

Raw material costs

£4 per kg

£2 per kg

£1 per litre

Table MA.2

Indirect costs*

£k

Rent

18.2

Utilities

13.8

Factory administration

12.7

Marketing and sales

47.4

Administrative salaries

38.5

factory indirect costs are currently allocated on a blanket rate.

Packaging is estimated at £200 per 1,000 bars.

Direct labour costs are expected to be £10 per hour.

Table MA.3 Sales director’s volume and price assumptions

Increase price

Decrease volume

Dark chocolate bars

10%

10%

Milk chocolate bars

5%

5%

White chocolate bars

No change

No change

Table MA.4 Fruit and nut: raw material costs

Per bar

Quantity

Cost

Cocoa, sugar, and milk

Assume 50% of milk bar

Fruit

50g per bar

£4 per kg

Nut

50g per bar

£8 per kg

Direct labour, packaging,

and factory overhead

Cost per bar: use same assumptions

as other chocolate bars
Sales revenue budget
Dark milk white total
Volume 80000 140000 60000 280000
selling price per bar 2 1,8 2
total sales revenue 160000 252000 120000 532000
Raw materials
dark milk white total
volume 80000 140000 60000 280000
cocoa per bar 0,17 0,13 0 0,3
total cocoa used 13600 18200 0 31800
cost per kg 4 4 4 4
total cocoa cost 54400 72800 0 127200
volume 80000 140000 60000 280000
sugar per bar 0,03 0,04 0,07 0,14
total sugar used 2400 5600 4200 12200
cost per kg 2 2 2 2
total sugar cost 4800 11200 8400 24400
volume 80000 140000 60000 280000
milk per bar 0 0,03 0,13 0,16
total milk used 0 4200 7800 12000
cost per kg 1 1 1 1
total milk cost 0 4200 7800 12000
Packaging
dark milk white total
volume per thousand 80 140 60 280
cost 200 200 200 200
total packaging cost 16000 28000 12000 56000
Direct labour
dark milk white total
volume 80000 140000 60000 280000
hours (volume/20) 4000 7000 3000 14000
per hour cost 10 10 10 10
total direct labourcost 40000 70000 30000 140000
Income statement
sales revenue 532000
direct materials
cocoa 127200
sugar 24400
milk 12000 163600
direct labour 140000
ackaging 56000
indirect costs
rent 18200
utilities 13800
factry administration 12700
marketing and sales 47400
administrative salaries 38500 130600
Net income 41800
Management can assure themselves about the estimate by considering the market price and market survey.
b) Analysis
dark milk white total
volume 80000 140000 60000 280000
weight 0,285714286 0,5 0,214285714
sales revenue 160000 252000 120000 532000
Direct materials:
cocoa 54400 72800 0 127200
sugar 4800 11200 8400 24400
milk 0 4200 7800 12000
packaging 16000 28000 12000 56000
indirect costs 37314,28571 65300 27985,71429 130600
total costs 112514,2857 181500 56185,71429 350200
profit 47485,71429 70500 63814,28571 181800
net profit margin 0,296785714 0,279761905 0,531785714 0,341729323
Current profitability:
dark milk white
sales volume 80000 140000 600002
selling price/unit 2 1,8 2
Raw materials/unit
cocoa 4/1000*170,*130,*0 0,68 0,52 0
sugar 2/1000*30,*40,*70 0,06 0,08 2,8
milk 0,1/1000*30,*130 0 0,03 0,13
R/Mat.Total 0,74 0,63 2,93
direct labour 1/20*€10 0,5 0,5 0,5
total direct costs 1,24 1,13 3,43
Contribution/unit 0,76 0,67 -1,43
total contribution sales*contn/unit 60800 93800 -85800
68800

PLEASE SHOW WORK IN EXCEL

The Masters Corporation purchased a piece of machinery for$300,000. The expected useful life (EUL) of the machine is 10years. Machinery of this type normally has a salvage value ofapproximately 17 percent of the purchase price (use $50,000 forsalvage value in this case.) Using the accounting/finance functionsin Excel, complete the depreciation worksheet in Exercise11.xls inthe following steps: 1. Use the following three methods to computethe depreciation in columns B, C, and D: (1) doubledecliningbalance, (2) straight-line, and (3) sum-of-the-years’ digits.Columns F, G, and H should show the book value of each method forthe 10 periods (10 years). Formulas should be used in the emptycells so that a change in the cost, salvage value, or expecteduseful life of the machinery automatically updates the worksheet.2. Print cells A8:H10 into one page with proper format. 3. Printcell formulas in Cells A15:H15. You may edit the cell formulas intoseveral lines if the cell formulas from Row 12 get to be too longto print into just one line. 4. Prepare a line chart of the bookvalue each year for each method and a bar chart showing the annualdepreciation amounts. Appropriately size and place both charts intoone page. 5. Print both charts in Step 4 into one page. Provideproper heading, legends, and size. 6. Change the cost of themachine to $500,000, and the salvage value to be 17% of thepurchase price as it is generally used in this industry, but keepthe expected useful life still at 10 years. Compute thedepreciation expenses and book values again using the threedepreciation methods. 7. Print cells A8:H10 into one page withproper format. Required: Printouts from Steps 2,3, 5 and 7.

COST 300000
SALVAGE 50000
LIFE 10
The Masters Corporation
Depreciation Analysis
Book Value
Yearly Depreciation PERIOD BV DD BV SL BV SYD
PERIOD DOUBLE D STRAIGHT SUM YRS 0 300000 300000 300000
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10 SALVAGE

2.5. Match the following terms with their definitions.

Term

_____a. dataprocessing cycle

_____b. source documents

_____c. turnaround documents

_____d. source data automation

_____e. general ledger

_____f. subsidiary ledger

_____g. control account

_____h. coding

_____i. sequence code

_____j. block code

_____k. groupcode

_____l. mnemonic code

_____m. chart ofaccounts

_____n. general journal

_____o. specialized journal

_____p. audittrail

_____q. entity

_____r. attribute

_____s. field

_____t. record

_____u. datavalue

_____v. master file

_____w. transactionfile

_____x. database

_____y. batchprocessing

_____z. online, real-time processing

Definition

1. Contains summary-level data for every asset, liability, equity,revenue, and expense account

2. Items are numbered consecutively to account for all items; missingitems cause a gap in the numerical sequence

3. Path of a transaction through a data processing system from pointof origin to final output, or backward from final output to pointof origin

4. List of general ledger account numbers; allows transaction data tobe coded, classified, and entered into proper accounts; facilitatespreparation of financial statements and reports

5. Contents of a specific field, such as “George” in a name field

6. Portion of a data record that contains the data value for aparticular attribute, like a cell in a spreadsheet

7. Company data sent to an external party and then returned to thesystem as input

8. Used to record infrequent or nonroutine transactions

9. Characteristics of interest that need to be stored

10. Thesteps a company must follow to efficiently and effectively processdata about its transactions

11. Something about which information is stored

12. Storescumulative information about an organization; like a ledger in amanual AIS

13. Contains detailed data for any general ledger account with manyindividual subaccounts

14. Contains records of individual business transactions that occurduring a specific time period

15. Updating each transaction as it occurs

16. Devicesthat capture transaction data in machine-readable form at the timeand place of their origin

17. Used torecord large numbers of repetitive transactions

18. Set ofinterrelated, centrally coordinated files

19. Two ormore subgroups of digits are used to code items

20. Updating done periodically, such as daily

21. Systematic assignment of numbers or letters to items to classifyand organize them

22. Lettersand numbers, derived from the item description, are interspersed toidentify items; usually easy to memorize

23. Initialrecord of a transaction that takes place; usually recorded onpreprinted forms or formatted screens

24. Fieldscontaining data about entity attributes; like a row in aspreadsheet

25. Sets ofnumbers are reserved for specific categories of data

26. Thegeneral ledger account corresponding to a subsidiary ledger, wherethe sum of all subsidiary ledger entries should equal the amount inthe general ledger account

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in