Reference no: EM131052109
Dorina Company makes cases of canned dog food
Spreadsheet Assignment Using Excel
Dorina Company makes cases of canned dog food in batches of 1,000 cases and sells each case for $15. The plant capacity is 50,000 cases; the company currently makes 40,000 cases. Doggie Mart has offered to buy 1,500 cases for $12 per case. Because product-level and facility-level costs are unaffected by a special order, they are omitted.
Required
a. Prepare a spreadsheet like the following one to calculate the contribution to income if the special= order is accepted. Construct formulas so that the number of cases or the price could be changed and the new contribution would be automatically calculated.
b. Try different order sizes (such as 2,000) or different prices to see the effect on contribution to profit.
Spreadsheet Tips
1. The numbers in cells F7 to F9 should be formulas that refer to F5. This allows the number of cases to be changed in cell F5 with the other cells changing automatically.
2. The formula in cell F10 uses a function named ROUNDUP to calculate the even number of batches. The formula should be _ ROUNDUP(F5/1000,0) where the zero refers to rounding up to the nearest whole number.
|
Differences between theories and principles
: 1: Bioethics tools are categorized as theories and principle approaches. What are the five theories and four principles? 2. What are the differences between theories and principles?
|
|
Prepare all journal entries for denizen corporation
: On December 1, 2008, Denizen Corporation entered into a 120-day forward contract to purchase 20,000 Canadian dollars (C$). Prepare all journal entries for Denizen Corporation.
|
|
Classify the kinds of data analysis and statistical methods
: classify the kinds of data analysis and statistical methods
|
|
Oxidation-reduction potential difference
: The relationship between an oxidation-reduction potential difference and the standard free energy change is (where n is the number of moles of electron transferred, F= Faraday's constant and E°= standard oxidation-reduction potential difference)
|
|
Calculate the contribution to income
: Prepare a spreadsheet like the following one to calculate the contribution to income if the special= order is accepted. Construct formulas so that the number of cases or the price could be changed and the new contribution would be automatically ca..
|
|
How many addresses are left
: Create 4 subnets for this organisation with the first subblock of 120 addresses, the second subblock of 60 addresses, the third subblock of 30 addresses and the fourth subblock of 12 addresses. (1.5 marks for each correct answer)
|
|
Tailored to particular types of organizations
: Why is it important to have a chart of accounts that is tailored to particular types of organizations rather than one chart of accounts that applies to all types of organizations?
|
|
Describe how would handle situation using normative ethics
: In applied ethics, you do not deal with the facts of individual cases. You focus on applying ethical rules to a class of cases. Describe the class or type of case represented here.
|
|
Three examples of organizations
: Give at least three examples of organizations that have used IS in innovative ways to gain competitive advantage. For each example, which of Porter's framework elements does it illustrate?
|