(Answered) Dorina company makes cases of canned dog foodspreadsheet

Accounting

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.

View complete question

Financial Accounting, Accounting

Category:- Financial Accounting
Reference No.:- M91776526
Price:- $25

Verified Expert

Priced at $50 Now at $25, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Financial Accounting

Corporate accounting assignment -assessment task -select

Corporate Accounting Assignment - Assessment task - Select two public limited companies listed on the Australian Securities Exchange (ASX) that are in the same industry. Go to the website of your selected companies. Then ...

Assignment -part a -background saturn petcare australia and

Assignment - Part A - Background: Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since openin ...

The ipl just signed sachin to a contract consisting of

The IPL just signed Sachin to a contract consisting of eight, end-of-year payments worth $9 million each, with the first payment precisely one year from today. On the other hand, Dhoni recent deal calls for six annual pa ...

Establish and maintain accounting info systems and provide

Establish and maintain accounting info systems and Provide management accounting information Assignment - Assignment 1 - Case Studies Case Study 1 - Review the case study information below and complete the steps mentione ...

On december 1 of the current year the following accounts

On December 1 of the current year, the following accounts and their balances appear in the ledger of Latte Corp., a coffee processor: Preferred 2% Stock, $50 par (240,000 shares authorized, 86,000 shares issued)$4,300,00 ...

Part adbm financial solutionsyou are a financial consultant

Part A DBM Financial Solutions You are a financial consultant working with DBM Financial Solutions and have a portfolio of clients you work with in achieving financial management solutions. Client 1- Manhattan Limited Yo ...

What has been strides position on dividend payouts in the

What has been Strides' position on dividend payouts in the past (pattern, relationship with earnings, etc.)? What factors affected its dividend policy?

Sweet treats common stock is currently priced at 3672 a

Sweet treats common stock is currently priced at $36.72 a share. The company just paid $2.18 per share as its annual dividend. The dividends have been increasing by 2,2 percent annually and are expected to continue doing ...

Ha 3011 advanced financial accounting assignment

HA 3011 Advanced Financial Accounting Assignment - Assessment Task Part A - In an article entitled 'Unwieldy rules useless for investors' that appeared in the Australian Financial Review on 6 February 2012 (by Agnes King ...

Company a is a calendar year company that depreciates all

Company A is a calendar year company that depreciates all its machinery on a straight-line basis. On January 1, 2016, the company purchased machinery costing $100,000, with an estimated useful life of 10 years and a zero ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Accounting Expert