Question Details

Answered: - Data Items # Head of cattle # Head bought/sold per


Decision Making Excel - CIS 1220

I need help this assignment and how to complete it?

My instructor provide attachment of Cattle Data File .xlsx along with this assignment
Data Items

 

# Head of cattle

 

# Head bought/sold per year

 

Days/year

 

Tax rate

 

$/lb Calf

 

$/lb Steer/heifer (mature)

 

$/hour Labor

 

Hours/wk Labor

 

#./lbs per Calf

 

#/lbs Steer/heifer (mature)

 


 

$

 

$

 

$

 


 

300

 

200

 

365

 

15%

 

0.74

 

0.75

 

15.00

 

15

 

400

 

1,400

 


 

Feed Requirements and Cost of Feed

 


 

Age Category

 

Calf

 

yearling

 

Mature

 

Total

 


 

Weight Category

 

600

 

900

 

1400

 


 

ID

 

383

 

230

 

118

 


 

Age Category

 

calf

 

calf

 

calf

 


 

197

 


 

yearling

 


 

235

 

119

 


 

yearling

 

yearling

 


 

273

 


 

calf

 


 

311

 

120

 


 

yearling

 

calf

 


 

349

 


 

calf

 


 

387

 

121

 


 

calf

 

calf

 


 

425

 


 

yearling

 


 

463

 

122

 


 

calf

 

yearling

 


 

501

 


 

yearling

 


 

539

 

123

 


 

calf

 

calf

 


 

577

 


 

yearling

 


 

615

 

124

 


 

mature

 

calf

 


 

653

 


 

yearling

 


 

691

 


 

mature

 


 

125

 


 

yearling

 


 

729

 

767

 

126

 

805

 

843

 

127

 

881

 

919

 

128

 

957

 

995

 

129

 

033

 

071

 

130

 

109

 

147

 

131

 

185

 

223

 

132

 

261

 

299

 

133

 

337

 

375

 

134

 

413

 

451

 

135

 

489

 

527

 

136

 

565

 

603

 

137

 

641

 

679

 

138

 

717

 

755

 

139

 

793

 

831

 

140

 

869

 

907

 

141

 

945

 

983

 

142

 

021

 

059

 

143

 

097

 


 

mature

 

yearling

 

mature

 

yearling

 

mature

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

mature

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

mature

 

mature

 

yearling

 

calf

 

mature

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

calf

 

calf

 

calf

 

yearling

 

calf

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 


 

Pounds of Feed per Animal per Day

 

Corn

 

14.48

 

17.59

 

22.47

 

54.54

 


 

Weight Category

 


 

Feed Prices

 


 

Hay

 


 

Soy

 

5.17

 

2.69

 

3.97

 

11.83

 


 

Corn

 


 

Total

 

1.03

 

0.41

 

0.00

 

1.45

 


 

Hay

 


 

Corn

 

20.69

 

20.69

 

26.44

 

67.82

 


 

Soy

 


 

Price

 

Unit

 

Price/lb

 


 

Hay

 

50

 


 

ton

 


 

Soy

 

0.02

 


 

pound

 

0.025

 


 

0.02

 

pound

 


 

0.02

 


 

0.02

 


 

135

 

144

 

173

 

211

 

145

 

249

 

287

 

146

 

325

 

363

 

147

 

401

 

439

 

148

 

477

 

515

 

149

 

553

 

591

 

150

 

629

 

667

 

151

 

705

 

743

 

152

 

781

 

819

 

153

 

857

 

895

 

154

 

933

 

971

 

155

 

009

 

047

 

156

 

085

 

123

 

157

 

161

 

199

 

158

 

237

 

275

 

159

 

313

 

351

 

160

 

389

 

427

 

161

 

465

 

503

 

162

 

541

 

579

 

163

 

617

 

655

 

164

 

693

 

731

 

165

 

769

 

807

 

166

 

845

 

883

 

167

 

921

 

959

 

168

 

997

 

035

 

169

 

073

 

111

 

170

 

149

 

187

 

171

 

225

 

263

 

172

 

301

 

339

 

173

 

377

 

415

 

174

 

453

 

491

 

175

 

529

 


 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

mature

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

calf

 

mature

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 


 

567

 

176

 

605

 

643

 

177

 

681

 

719

 

178

 

757

 

795

 

179

 

833

 

871

 

180

 

909

 

947

 

181

 

985

 

023

 

182

 

061

 

099

 

183

 

137

 

175

 

184

 

213

 

251

 

185

 

289

 

327

 

186

 

365

 

403

 

187

 

441

 

479

 

188

 

517

 

555

 

189

 

593

 

631

 

190

 

669

 

707

 

191

 

745

 

783

 

192

 

821

 

859

 

193

 

897

 

935

 

194

 

973

 

011

 

195

 

049

 

087

 

196

 

125

 

163

 

197

 

201

 

239

 

198

 

277

 

315

 

199

 

353

 

391

 

200

 

429

 

467

 

201

 

505

 

543

 

202

 

581

 

619

 

203

 

657

 

695

 

204

 

733

 

771

 

205

 

809

 

847

 

206

 

885

 

923

 

207

 

961

 


 

yearling

 

mature

 

yearling

 

yearling

 

calf

 

mature

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

mature

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

mature

 

yearling

 

yearling

 

mature

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

calf

 

calf

 

yearling

 

calf

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

calf

 

yearling

 

yearling

 

mature

 

yearling

 

calf

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 


 

999

 

208

 

037

 

075

 

209

 

113

 

151

 

210

 

189

 

227

 

211

 

265

 

303

 

212

 

341

 

379

 

213

 

417

 

455

 

214

 

493

 

531

 

215

 

569

 

607

 

216

 

645

 

683

 

217

 


 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

yearling

 

yearling

 

calf

 

yearling

 

yearling

 

calf

 

yearling

 

calf

 

calf

 

mature

 

yearling

 

calf

 

calf

 


 

Buckley's Cattle

 

Income Statement

 


 

Income

 

Sales Revenue

 

Cost of Sales

 

Gross Profit

 

Operating Expenses

 

New Calves

 

Cost of Feed

 

Loan Payments

 

Veterinary Expenses

 

Labor Expenses

 

Total Operating Expenses

 

Profit Before Taxes

 

Taxable Income

 

Taxes (15%)

 

Profit After Taxes

 

Profit per Head

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185100.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now